hide and exclude interactive

[#1]

Hello everyone,

Is it possible to make the "row selector" module interactive (to hide and exclude rows the user doesn't need)

Maybe with the help of “Model Dialog”?

Thank you for your answers.

[#2]

Is the Data Filter what you're looking for (Rows...Data Filter)? Selecting the "show" and "include" checkboxes makes the hide and exclude interactive. If not, can you clarify what you need a bit more, please?

[#3]

Good morning,

To be more precise, I have several test columns: value 1 if the column meets a condition, value 0 otherwise.

Depending on what I'm looking to study, I would like to be able to hide the observations with a value of 0 in the column that interests me.

Here this script will work for test a only, but I would like at best 1 only script in which it asks me which test I want to hide (test a,.....,test z).

The goal is not to repeat the same script n times. 

[#4 · Accepted solution]

I believe the following script will do what you are asking. Full script with sample data table attached.

cdg = Column Dialog ("Input Columns",
	cols = Col List ("Columns", Min Col (1), Data Type ("Numeric"));
);

for each ({i}, cdg["cols"],
	dt << select where (i == 0) << Hide and Exclude;
);

[#5]

Great thank you that is exactly what I needed.

Just a clarification, to go further after doing that, is it possible depending on the test column chosen by the user to launch a graph (with the column chosen interactively)?

For example: the user chooses the column "test c" and after having hidden the lines: the script launches the tool "Put in Table" according to the column test c with the options.

[#6]

Yes, assuming you're looking for the tabulate platform, here's code to grab the first of the selected columns (you could remove the [1] portion to use all the selected columns):

tab = Tabulate(
	Show Control Panel( 0 ),
	Set Format( Uniform Format( 10, 2 ) ),
	Add Table(
		Column Table( Analysis Columns( :Y ), Statistics( Mean, Std Dev ) ),
		Row Table( Grouping Columns( cdg["cols"][1] ) )
	)
);

[#7]

Modifying your code a bit, I get exactly what I was looking for

Thanks for your help !