cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
tom_abramov
Level V

Data Filter Conditional

With "Conditional" option enabled in Data filter, there are these circles with numbers.

In attached example, :weight is the third column in filter sequence.

The question is: is there some way to change the third column to :height

without reseting entire filter with "Clear" button?

Thanks.

Screen Shot 04-23-20 at 09.42 AM.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

Re: Data Filter Conditional

I believe you are correct. There is no way to reset the order of the conditional filters without clearing your selections and starting at (1) again.

 

Perhaps @chungwei can confirm.

-Jeff

View solution in original post

5 REPLIES 5
ian_jmp
Staff

Re: Data Filter Conditional

Not sure if this is what you are asking, but you can delete variables from their 'little red triangle' then add them back again. Using a script:

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

tab = dt << Tabulate(
	Show Control Panel( 0 ),
	Add Table( Row Table( Grouping Columns( :name ) ) )
	);


ldf = tab << Local Data Filter(
	Conditional,
	Add Filter(
		columns( :age, :sex, :weight),
		Where( :age == 14 ),
		Where( :sex == "M" )
		)
	);

Wait(2);
ldf << delete(:weight);
ldf << addFilter(Columns(:height));

 

Depending on the details of the use case, you might also be able to exploit the 'Favourites' feature of the local data filter.

tom_abramov
Level V

Re: Data Filter Conditional

Thanks,

I am looking for simple/without script/without delete solution.

The best solution may be a right click and "Remove from filter sequence" option or something.

I guess, there is no solution for this right now.

 

Jeff_Perkinson
Community Manager Community Manager

Re: Data Filter Conditional

I believe you are correct. There is no way to reset the order of the conditional filters without clearing your selections and starting at (1) again.

 

Perhaps @chungwei can confirm.

-Jeff
KarenC
Super User (Alumni)

Re: Data Filter Conditional

Hover over the weight section title and your pointer will become a hand...click and drag carefully up so it falls between your first and second selections...and drop.
tom_abramov
Level V

Re: Data Filter Conditional

Thank you.

Unfortunatly, changing column location in data filter doesnt change 

its filter sequence in conditional data filter logic

(if I drag weight column, it still has a circle with number three in it)