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
MargauxR
Level III

Subset data after filter

hello Everybody !

I have a problem in my script.

I have a big data table and i would like to subset some lines.

I did a data filter and then subset or show subset, but i don't have "time" to select the filter in the window....

how can i say in the script i have select first my filter and then subset the data table

i tried with a wait but it's not the best way

this is my script and i link my data base

thank you for your help !!

 

Margaux R
1 REPLY 1
txnelson
Super User

Re: Subset data after filter

Here is one way of handling the issue.  By wrapping the Data Filter in a Modal window you can stop the processing until the selections are made.

dt = Current Data Table();
nw = New Window( "zippy",
	<<modal,
	obj = dt << Data Filter(
		Location( {325, 213} ),
		Conditional,
		Add Filter(
			columns( :Propriétés, :Date d'analyse ),
			Display(
				:Date d'analyse,
				Size( 223, 63 ),
				List Display
			)
		)
	)
);
If( nw["button"] == 1,
	dtNew = dt << subset(
		selected columns( 0 ),
		selected rows( 1 )
	);
	dt << clear row states;
);

Jim