Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Belliappa
You can create sub-menu lists in opened state and show/hide them using main menu button actions
Lukasz
Yes, its possible in Container object.
Create Buttons and put them in container and open properties ,go to Appreance and Select DropDown at top.
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'
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
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