Menu and SubMenu

[New-Qlik]

Hi All,

I want to create menu n sub menu bottons/ panel

let say I  have 10 sheets naming

Sheet1

Sheet1.1

sheet1.2

sheet2

sheet3

sheet3.1

sheet3.2

sheet3.3

-

etc

I want to create menu bar saying Sheet1   Sheet2    Sheet3

and when someone click on Sheet1 a drop down should come with option of SHEET1.1 adnSHEET1.2 similarly for rest

I cant use extensions.

Thanks In Advance

[tajmohamed30]

you can try idea like having text objects one below other with show or hide option similarly looking like extension objects.

[hcabrera]

Hi,

may be

Menú de navegación sin extensiones

[New-Qlik]

yes that I am keeping it as last option as I don't like its layout. anything else we can do ?

[New-Qlik]

Anything in English.

[RSvebeck]

Most dynamic solution would be to create two data island tables:

menu:

load * INLINE [

Menu

Menu 1

Menu 2

Menu 3

];

submenu:

load * INLINE [

Submenu

Submenu 1

Submenu 2

Submenu 3

];

Then do listboxes of field Menu and Submenu.

Make them "Always one selected"

Then put sheet show/hide property based on values in those fields.

Robert

[New-Qlik]

Thanks Robert but I dint get one thing

how do I do that on clicking menu1 this sheet should get open

example click menu1--->opens up sheet1

click menu2 --> sheet2 opens up

Thanks

[ElizaF]

Hello,

Check the below blog post, it should give you a good idea:

QlikView App - Show and Hide Sheets based on User or Menu

QlikView App: At The Qlik Of A Button

dropdown menu extension

[RSvebeck · Accepted solution]

1. Go to sheet properties.

2. Locate the "Show Sheet" setting, and choose "Conditional".

3. Type in this code in the box: Menu='Menu 1'

4. Do the same for all sheets, but change the formula to those:

• Menu='Menu 1' and Submenu='Submenu 1'
• Menu='Menu 1' and Submenu='Submenu 2'
• Menu='Menu 2'
• Menu='Menu 2' and Submenu='Submenu 1'
• Menu='Menu 2' and Submenu='Submenu 2'

etc.

I attach an example app.