Qlik Community

QlikView Documents

Documents for QlikView related information.

Alternative Sheet navigation (instead of the tab row)

Employee
Employee

Alternative Sheet navigation (instead of the tab row)

In some apps the tab row is not the page navigation of choice and you would like to have a vertical menu or an image bar.

It is likely common knowledge that you can disable the tab row in the document properties and use buttons or text boxes with "Open Sheet" actions instead. This leads to some extra maintenance effort (new sheet, new objects, new actions).

The attached approach scans the base QVW for new or changed sheet names and adjusts automatically. You have all sheet entries in only one object! (which is a standard QV object, not an extension). So it is close to zero maintenance.

Custom Sheet Navigation.png

Enjoy

Tags (2)
Attachments
Comments
Not applicable

Please, can you tell me how do you link the current SheetID selection with the qlikview data model?

juleshartley
Valued Contributor

Excellent. Great method of implementation - thanks!

juleshartley
Valued Contributor

Should be pointed out that I think there is some v.11 functionality - namely the actions on objects...

Not applicable

I was looking for some stuff to check which sheet is selected but unfortunately in ajax sheet onload event is not working properly.

Employee
Employee

Yes, if you are using OnOpen actions on the sheets, too, Ajax Client will not execute them. This is a documented limitation, that Ajax Client can only handle one chain of actions at a time. Since in my above app, the (hidden) field ##SheetTitle already has a OnSelect action which activates the desired sheet. This is "one chain of actions" that's why Ajax Client would not execute possible Sheet OnOpen actions. If you cannot avoid row looks without hijacking of field OnSelect events etc. see http://community.qlik.com/thread/97972

Version history
Revision #:
1 of 1
Last update:
‎11-04-2013 09:20 AM
Updated by:
Employee