413850_en-US

liliconcom

"Order by count" do not work in a conditional data filter

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 :age do not sort by count in the data filter.

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
 )
);

 

ScriptingRe: "Order by count" do not work in a conditional data filter

Dear sir, many thanks to you.
I had sent this question to support@jmp.com. 

thanks.