topic Re: How to create menu, where app contains multiple sheets in QlikView

How to create menu, where app contains multiple sheets

bell_byloli — Fri, 07 Feb 2014 08:59:50 GMT

hello,

i have an app with 20+ sheets, i want to create a main page, which contains the link to all the sheets. i am aware i can use buttons>>action to activate any sheet. However, is it possible to have a smart menu, instead of having 20 + buttons on a single sheet.

is it possible to group the buttons , lets say to 3 dropdowns(menu).ie. i will just have 3 main buttons, when i click the button it opens(just like in a multibox ) to show the sub menu under it containing rest of the buttons. As in the ribbon above where it says ""Select language" ( you click select language you get a menu ) without writing macros.

Re: How to create menu, where app contains multiple sheets

Fri, 07 Feb 2014 09:04:09 GMT

Hi Belliappa

You can create sub-menu lists in opened state and show/hide them using main menu button actions

Lukasz

Re: How to create menu, where app contains multiple sheets

ashwanin — Fri, 07 Feb 2014 09:09:14 GMT

Yes, its possible in Container object.

Create Buttons and put them in container and open properties ,go to Appreance and Select DropDown at top.

Re: How to create menu, where app contains multiple sheets

Fri, 07 Feb 2014 21:08:03 GMT

You can create a list of Section/ sheet names in inline load script. and create a selection list in menu page.

use showcondition for ever sheet like : getfieldselection='Section/ sheet name'

Re: How to create menu, where app contains multiple sheets

stevedark — Sat, 08 Feb 2014 23:04:14 GMT

Hi Belliappa,

The best way of achieving this is by using the Show / Hide condition on the buttons. When clicking on one of the first set of buttons this can set a variable that then sets the show condition on the next set of buttons.

Rather than just navigating to the right page from those buttons you could also fire show/hide conditions on the sheets, so only one set of sheets is visible at once.

If you look at my example file and associated blog post on QlikView Buttons it should give you a good idea: QlikView App: At The Qlik Of A Button

A couple of extra tips, I would use text boxes as buttons (rather than the default QlikView lozenges). Also, I would colour the groups of tabs the same as the colour of the buttons - this should make things far easier to navigate.

I have an example of showing and hiding sheets in this way somewhere - I will have to dig it out...

Hope that helps,

Steve

Re: How to create menu, where app contains multiple sheets

stevedark — Sun, 09 Feb 2014 00:32:03 GMT

I've found the app I had with the sheets showing and hiding, tidied it up a bit and uploaded it to the Community as a Shared Document.

It may take a while to be moderated, but it should appear here soon: QlikView App - Show and Hide Sheets based on User or Menu

Hope it helps.

Steve