Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to create navigation frame in Qlikview.
Tried with container object and Extensionable object.
If the user clicks the value , specific sheet should be activated.
Example :
Branch if user clicks on Branch summary , sheet 3 should be opened.
Please suggest me how to acheive and please find attached sample.
Thanks in advance
Regards,
Qlikview Sam
you can put a show/hide rule on the sheet so lets say the user select "Branch Summary" in
field SheetSelection
so in sheet3 put this rule
show sheet :
index(getfieldseletion(SheetSelection),'Branch Summary')>0
Not a very elegant solution but this sample would do the trick.
Introduce sheetID as a field and leverage triggers for selections in your sheet name field.
This will activate your sheet. There is also a conditional show on a sheet that uses a variable and triggers aswell to hide/show your sheet depending on selection.
But I would probably do this with a document extension instead so you have a nice navigation pane that is dynamic, requires qv11 though
Here is an extension object that might do the trick.
Alexander - would there be any benefit to doing this as a document extension?