Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?