topic Fill a listbox dynamically by choosing a dimension in QlikView

Fill a listbox dynamically by choosing a dimension

Sat, 26 Nov 2011 20:38:42 GMT

I employ an input box which succesfully captures chosen dimensions in variables.

While referring to these variables in a graph, they dynamically take the chosen dimension as stored in the variable.

The expression used in the chart is simply a referral to the variable, for instance : vChosenDimension.

I did the same in a listbox while choosing expression instead of an existing field, but.. the listbox remains empty.

Do you know how to refer to a variable to have a dynamic listbox?

Fill a listbox dynamically by choosing a dimension

swuehl — Sat, 26 Nov 2011 20:59:52 GMT

Have you tried

=$(vChosenDimension)

as field expression in your list box?

Fill a listbox dynamically by choosing a dimension

Sat, 26 Nov 2011 21:53:19 GMT

Hi Swuehl

Thanks for the advice,now it works, great. So I have to exclamate the default state through $, didn't know because i thought variables ignorant to states

Fill a listbox dynamically by choosing a dimension

swuehl — Sat, 26 Nov 2011 22:03:31 GMT

Here, $ does not indicate the current selection state like in a set expression, it is indicating a so called dollar sign expansion (please check out the Help file for more infos on that).

Regards,

Stefan