nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Filter Conditional

tom_abramov

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

Accepted answers

Jeff_Perkinson

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.

All comments

ian_jmp

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.

KarenC

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

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)

tom_abramov

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

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.