topic Re: the menu in QlikView

the menu

Wed, 18 Jun 2014 04:37:30 GMT

hi, i want to make something like wat i have attached with this.how could i make it??

Thanks and regards

Darshika

Re: the menu

tresB — Wed, 18 Jun 2014 04:48:12 GMT

May be like attached, using buttons.

Re: the menu

Wed, 18 Jun 2014 04:54:07 GMT

hi,

thanks for ur reply but i want the left menu like it is mentiomed in the picture.and it should be dynamic like wen i click to it it should show the sub menu under the main menu and wen i click to the sub menu it should show me my desired kpi or graph

Re: the menu

tresB — Wed, 18 Jun 2014 04:58:00 GMT

Use text box/button and add action to it. For moving to new sheet you can use activate sheet trigger. For sub menu (activating kpi /graph) use conditional enablement for the object againds a variable balue. Use the text box action to set the variable value.

Re: Re: the menu

tresB — Wed, 18 Jun 2014 05:09:21 GMT

PFA

Re: the menu

Wed, 18 Jun 2014 05:23:47 GMT

Dear Darshika

use this below code and add list box "TreeMenu" your menu will be Hierarchy view check this out

Employee:

LOAD * INLINE [

EmployeeID, Name, Email, ManagerID

1, Ahsan, g@co.com

2, Abid, ss@co.com,

3, Kashif, f@co.com,

4, Maria, j@co.com, 1

5, noman, m@co.com, 2

6, kamran, e@o.com, 2

7, zeeshan, e@o.com, 3

]

;

Hier:

Hierarchy (EmployeeID, ManagerID, Name, ManagerName, Name, TreeMenu)

LOAD EmployeeID, ManagerID, Name, recno() as recno

RESIDENT Employee

;

Re: Re: the menu

amit_saini — Wed, 18 Jun 2014 05:36:05 GMT

Hi Darshika,

Please see the attachment for "Tree Structure".

Thanks,