Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Creator III
Creator III

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

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

 

3 Replies
rubenmarin

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.

curiousfellow
Creator III
Creator III
Author

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

rubenmarin

A workaround can be selecting values using triggers.

Sample attached, triggers are configured in document properties.