topic Re: Vallue Listbox 2 depends on Listbox 1, and in listbox 2 only one value maybe selected in QlikView

Vallue Listbox 2 depends on Listbox 1, and in listbox 2 only one value maybe selected

curiousfellow — Fri, 10 Jan 2020 12:40:56 GMT

I want users to be able to select from listbox1 what dimensions should be displayed in Pivot table -----works

I want a second listbox with the values selected in listbox1----works

Only one value may be selected in listbox2--- works

However, when one value is selected iin listbox2 it is not possible to select multiple values in listbox1

Please see attached sample. How to change this.

The dimension in listbox2 should be used to calculate a Total, so the other dimensions can be used to calculate as a percentage of value listbox2

Re: Vallue Listbox 2 depends on Listbox 1, and in listbox 2 only one value maybe selected

rubenmarin — Sat, 11 Jan 2020 11:50:01 GMT

Hi, if you have %key_code in both tables selections in listbox2 will filter selections in listbox1, and if listbox2 have only one possible value listbox1 will have only that posiible value.

You can remove %key_code to have both tables as islands, so selections in one listbox won't filter the other listbox.

Re: Vallue Listbox 2 depends on Listbox 1, and in listbox 2 only one value maybe selected

curiousfellow — Sat, 11 Jan 2020 13:52:57 GMT

That's a pitty, listbox 2 should only display the valus selected in Listbox 1

Re: Vallue Listbox 2 depends on Listbox 1, and in listbox 2 only one value maybe selected

rubenmarin — Mon, 13 Jan 2020 11:56:59 GMT

A workaround can be selecting values using triggers.

Sample attached, triggers are configured in document properties.