topic Re: Two Independent ListBoxes in QlikView

Two Independent ListBoxes

lain_ — Mon, 06 Jul 2020 22:54:12 GMT

I have two sheets and one listbox on each sheet, both with the same dimensions. The problem right now is that when I make a selection on one listbox or change the properties in one listbox, the other one changes to match it. How do I make it so that whatever I do to one listbox doesn't affect the other? In each sheet, I also have other objects that reference these list boxes. These objects should only reference the listbox in the same sheet.

Re: Two Independent ListBoxes

rwunderlich — Tue, 07 Jul 2020 00:15:48 GMT

You said you when you change properties both listboxes change. This indicates these are Linked Objects. First, unlink by right-clicking one of the objects and selecting Linked Objects -> Unlink This Object.

Selections in either listbox will still affect both sheets. To make them work independently, put one of the sheets in an Alternate State.

1. In the Document Properties, General tab, click the "Alternate States" button. Define a state and give it a name, for example "stateA".

2. On Sheet properties , General tab of one of the sheets, select stateA in the Alternate State dropdown.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Two Independent ListBoxes

lain_ — Tue, 07 Jul 2020 14:51:07 GMT

The list box didn't have the unlink object option so I changed its state like you said and it worked!