Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qliklearnervir
Creator
Creator

how to show same hierarchical list in all sheet with append selection

I have 1 list box as tree view and i want to show this list box in all sheet.

clipboard_image_0.png

the issue is, when I select any value in this list box in sheet1, I want the same list and selected value as expended should show in sheet 2.

but the issue is in sheet 2 it showed like: not same expended like image 1.

clipboard_image_1.png

Labels (1)
13 Replies
Frank_Hartmann
Master II
Master II

Maybe you need to expand your listbox and then save the document.

right mouse click into listbox --> then click: Expand all --> save the qvw

 

hope this helps

qliklearnervir
Creator
Creator
Author

no, still the response is the same .

I need when I expand and collapse the list box, same should happen in list box available in other sheets.

i want to use this list box as the sheet navigation bar and should be responsive.

but when i expand the list box in sheet 1 , list box in sheet 2 with same object id does not change responsive.

 

please suggest if we can do something by action/trigger or by macro code.

 

Frank_Hartmann
Master II
Master II

what happens if you push the + sign in front of DeliveryHead.

if i do this, the listbox on the other sheet adapts automatically!

qliklearnervir
Creator
Creator
Author

can you show me how it's possible?

i am  selecting Chairman-->CEO-->DeliveryHead   in sheet1 list box.

clipboard_image_0.png 

 

now see sheet 2 Listbox

Spoiler
 

..

clipboard_image_1.png

 

I want sheet1 and sheet2 should show the same expand and collapse and vice versa.

but nothing working.

can you post a short video, how you are doing these things perfectly?

Frank_Hartmann
Master II
Master II

not able to upload any pic or gifs to the forum right now. I uploaded the gif to my dropbox:

https://www.dropbox.com/s/sput4c4gh86n4or/test.gif?dl=0

qliklearnervir
Creator
Creator
Author

Please guide me with steps i think i am missing something while designing this scenario.

Frank_Hartmann
Master II
Master II

did you see the gif/video?

is this the expected behaviour?

 

qliklearnervir
Creator
Creator
Author

Yes, same i want as whenever i click on + sign of any of list box , it should work vice versa.

so that i can use it in different sheets .

 

Frank_Hartmann
Master II
Master II

which qlikview version are you using?