Displaying menu list

[#1]

Hi ,

We need to display individual qlikview sheets as heirarchy of menus (different levels which are displayed on mouse roll over) so that the user can navigate and click on the relevent item in the list to view the sheet.

For eg: sample menu:

main menu : Automobiles

sub menu :1 cars (cars names to appear on mouse roll over)

sub menu 2: Volkwagen (price to appear on mouse roll over)`

sub menu 3: Price (heirarchy ends here)

BMW (body parts to appear on mouse roll over)

Body parts (transaction details to appear on mouse roll over)

sub menu 4: Transaction details (heirarchy ends here)

Color

Specifications

Audia

Dealers

When i click on "cars" , the list of cars should be listed and on clicking on one car should show me the list within that heirarchy (eg: clicking on BMW should list me "body parts") above mentioned sub menus are individuals sheets with its own analytics in it. The menu is classified according to the business requirements. We tried our hands on buttons option but we could not make a succesful attempt. We are not sure of any indirect method of acheiving this requirement also.

It would be really great if someone can help us on this.

[martijn]

Hi,

Do you mean a listbox shown as Treeview? You can create one of those in de script using the Hierarchy function...

Cheers

[#3]

Hi Martin,

Thanks for your valuable time. Here I am talking about sheets as heirarchies. I understand that treeview can provide object heirarchies. But We need qlikview sheets as heiarrchies. Can you throw up soem light on that?

Thanks in Advance,

Dhyanesh

[#4]

I am attaching a sample app that displays the sheets as hierarchies for your reference. There is a trigger onSelect placed when a TreeView item is selected which will in turn open the corresponding sheet. You would probably need to create a number of sheets plus hardcoded values to suit your needs.

[#5]

Hi,

This helps. thanks a lot. Is there any way by which we can hide all the sheets except the main sheet which has the tree view? They should show up only when i click the respective line item in the tree view.

Thanks in Advance,

Dhyanesh

[#6]

Go to Document Properties > General and select on the Hide Tabrow option.

You would still need the tree view in every sheet in order to go back to the main sheet, unless you create a link/button to the main sheet for each non-main sheet to go back.