topic Re: Connectred list box in QlikView

Connectred list box

Anonymous — Wed, 21 Nov 2012 22:39:45 GMT

Dear all,

is it possible to connect two listbox ?

Choosing a value into the first one, I would have the same value into the second:

For example I could choose October in the first listbox and the second one should have the same month.

Thanks for youe help

Re: Connectred list box

simondachstr — Wed, 21 Nov 2012 22:55:57 GMT

Depends - are you talking about two different fields which contain the same month? Like Sales_Year & Revenues_Year?

Then I suggest working with triggers. Choose 'Select Field', put in the name of your second listbox/field and in the selection box:
='=sum({<[Listbox2_fieldname]=[Listbox1_fieldname]>}1)'

Don't forget to include the same trigger 'On Change' if necessary.

Let me know if this helps you.

Re: Connectred list box

Gysbert_Wassenaar — Thu, 22 Nov 2012 11:06:04 GMT

See attached example. See the actions on the OnSelect trigger of Field Prod1 to see how this is done.

Re: Connectred list box

Anonymous — Sun, 02 Dec 2012 10:17:18 GMT

Thanks !!!