topic Re: Menu and SubMenu in QlikView

Menu and SubMenu

New-Qlik — Mon, 29 May 2017 17:23:57 GMT

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

Re: Menu and SubMenu

tajmohamed30 — Mon, 29 May 2017 17:43:02 GMT

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

Re: Menu and SubMenu

hcabrera — Mon, 29 May 2017 17:50:14 GMT

Hi,

may be

Menú de navegación sin extensiones

Re: Menu and SubMenu

New-Qlik — Mon, 29 May 2017 17:54:21 GMT

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

Re: Menu and SubMenu

New-Qlik — Mon, 29 May 2017 17:55:03 GMT

Anything in English.

Re: Menu and SubMenu

RSvebeck — Mon, 29 May 2017 20:33:55 GMT

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

menu:

load * INLINE [

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

Re: Menu and SubMenu

New-Qlik — Tue, 30 May 2017 05:53:42 GMT

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

Re: Menu and SubMenu

ElizaF — Tue, 30 May 2017 06:03:49 GMT

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

Re: Menu and SubMenu

RSvebeck — Tue, 30 May 2017 07:08:06 GMT

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.