cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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)