topic Re: Re: Input Box Selection in QlikView

Input Box Selection

Tue, 18 Mar 2014 21:19:47 GMT

I would like to know if there is a way to apply a selection based on an input box(s)? I have a need to limit a $ amount to a range and this range needs to be applied to the entire dashboard. I know I can do this with Set analysis, but as mentioned before I need to apply to entire dashboard. The $ ranges can vary anywhere from $0 to $500,000,000.

Re: Input Box Selection

rwunderlich — Tue, 18 Mar 2014 21:27:12 GMT

You can create an OnInput trigger for the variable that uses the variable value to Select In Field.

-Rob

Re: Input Box Selection

Tue, 18 Mar 2014 22:02:01 GMT

Attached is an example of what Rob mentioned.

Thanks

Re: Re: Input Box Selection

Tue, 18 Mar 2014 22:07:45 GMT

Thanks Rob,

I think I am almost there. I added the OnInput trigger for both my Min and Max variable. Problem is I can't get it to look for the range. It does the selection for the min or the max.

Re: Re: Input Box Selection

Tue, 18 Mar 2014 22:08:53 GMT

Thanks Ajay, please see sample on reply to Rob. I am needing a range with a Min and Max,

Re: Re: Re: Input Box Selection

Tue, 18 Mar 2014 22:23:16 GMT

Attached. Hope it helps. Please look at the back-end script and the variable trigger.

Thanks

Re: Input Box Selection

rwunderlich — Tue, 18 Mar 2014 22:30:31 GMT

Kevin,

You are close. You just need to use this selection string for both triggers.

='>=$(vMinTS)<=$(vMaxTS)'

-Rob

Re: Input Box Selection

Tue, 18 Mar 2014 22:33:00 GMT

Thanks!