Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lain_
Contributor III
Contributor III

Two Independent ListBoxes

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.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

lain_
Contributor III
Contributor III
Author

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