Dear sirs:
I try to use the "conditional" and "order by count" in the same data fitler.
It can work by manual select, but do not work in the JSL.
The "sort by count" don't work when "conditional" in the same data filter. (please refer following JSL code)
Could any big boss can help? thanks.
Thanks.
Order by count can't work in this JSL:
dt = open("$sample_data\big class.jmp");
dt << Data Filter(
Location( {912, 237} ),
Conditional,
Add Filter(
columns( :sex, :age ),
Where( :sex == "F" ),
Where( :age == 12 ),
Display( :age, N Items( 6 ) ),
Order By Count( :age ) //this should let :age order by count in the data filter, but don't
)
);
Order by count can work in this JSL("conditional" change to comment block):
dt = open("$sample_data\big class.jmp");
dt << Data Filter(
Location( {912, 237} ),
//Conditional, //hi, i change to comment block
Add Filter(
columns( :sex, :age ),
Where( :sex == "F" ),
Where( :age == 12 ),
Display( :age, N Items( 6 ) ),
Order By Count( :age ) //:age order by count can work when "conditional" change to comment block
)
);