627858_en-US

liliconcom

hide and exclude interactive

 

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.

Automation and ScriptingScriptingRe: masquer et exclure interactif

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?

 

Re: hide and exclude interactive

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. 

Re: masquer et exclure interactif

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;
);

Re: hide and exclude interactive

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.

Re: masquer et exclure interactif

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] ) )
 )
);

Re: hide and exclude interactive

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

 

 

Thanks for your help !

 

Re: masquer et exclure interactif

Thank you sir for the script.I will try too. Are you on the lookout for the best online essay writers? Look no further than https://www.topwritersreview.com/reviews/domyessay/  this website offers a comprehensive list of top-rated essay writing services that you can browse through to select the perfect fit for your needs.