Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS

Alternative Sheet navigation (instead of the tab row)

ChristofSchwarz
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?

0 Likes
juleshartley
Specialist
Specialist

Excellent. Great method of implementation - thanks!

0 Likes
juleshartley
Specialist
Specialist

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

0 Likes
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.

0 Likes
ChristofSchwarz
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

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