topic Re: Limit ListBox Options depending on Variable in QlikView

Limit ListBox Options depending on Variable

Tue, 18 Dec 2012 15:49:43 GMT

Hi,

Im currently using a variable to limit the values in a pivot table using this expression if(dashboard=vIndicator, sum(value)) .

The only drawback with this is all the availble options are shown in my filter. Is it possible to limit the values shown in my 'Question' filter depending on what variable is held in vIndicator?

For example my data set has a number of questions split to 2 Dashboard Values. At the moment all the questions are shown in the filter regardless of what variable has been selected by the user.

Many thanks for your help!!

Fiorano

Re: Limit ListBox Options depending on Variable

Gysbert_Wassenaar — Tue, 18 Dec 2012 15:58:07 GMT

You can use a OnInput Variable Event Trigger to make a selection in a field with a Select in Field action. It sounds like you want to select in field dashboard and set the search string to =vIndicator

Re: Limit ListBox Options depending on Variable

Tue, 18 Dec 2012 16:01:35 GMT

Hi,

Many thanks for your reply. Can you elaborate a little please - Im very new to Qlikview...

Many thanks!!

Fiorano.

Re: Limit ListBox Options depending on Variable

Gysbert_Wassenaar — Tue, 18 Dec 2012 16:08:18 GMT

See attached file. If you input a product name in the input box you'll notice that the selection of the Product listbox changes, as does the chart. On the Triggers tab of the Document properties you can see that the variable value has an action assigned to it. If you click on the button Edit Action(s) under OnInput you can inspect the action and its arguments.

Re: Limit ListBox Options depending on Variable

Tue, 18 Dec 2012 16:13:08 GMT

That is very helpful!

thanks!