topic Re: Data Filter Conditional in Discussions

Data Filter Conditional

tom_abramov — Thu, 23 Apr 2020 06:58:39 GMT

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.

Re: Data Filter Conditional

ian_jmp — Thu, 23 Apr 2020 11:58:58 GMT

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.

Re: Data Filter Conditional

KarenC — Thu, 23 Apr 2020 22:38:29 GMT

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.

Re: Data Filter Conditional

tom_abramov — Sun, 26 Apr 2020 12:11:56 GMT

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)

Re: Data Filter Conditional

tom_abramov — Sun, 26 Apr 2020 12:15:17 GMT

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.

Re: Data Filter Conditional

Jeff_Perkinson — Sun, 26 Apr 2020 15:38:27 GMT

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.