Qlikview Navigation help

[#1]

Hi All,

Greetings for the day!

I have 5 sheets in my QVW Main,Area1-U1,Area1-U2,Area2-U1,Area2-U2.

In Main sheet i have 2 list boxes Area, Unit. If user select Area1 as Area and U1 as Unit then 'Area1-U1' sheet should enable.

If user select multiple Areas like Area1,Area2 and Unit as U1 then 'Area1-U1' and 'Area2-U1' sheets should enable.

If user select multiple Areas like Area1,Area2 and Unit as U1 and U2 then 'Area1-U1' and 'Area1-U2' and 'Area2-U1' and 'Area2-U2' sheets should enable.

Please help me here i am attaching sample QVW also.

Thanks,

QV11 User

[Chanty4u]

use show hide objcts

[#3]

Hi Suresh,

Thanks for reply.

Can you attach sample QVW?

Thanks,

QV11 User

[maxgro · Accepted solution]

see the attachement, in tab general of each sheet properties

but i suggest to simplify the user interface, and use one sheet with one chart and the 2 listbox

[sfatoux72]

Hi,

Exactly same answer as Maxgro, but he was quicker than me.

I just use a different expression to show/hide sheet:    

=GetFieldSelections(Area) like '*Area1*' and GetFieldSelections(Unit) like '*U1*'

But Idon't really understand why you want do that.

[HirisH_V7]

Hi ,

Well alternate state is the best way to achieve this, but you can also do this with the sheet activate and sheet de-activate triggers:

• On sheet activate, save the current selections in a bookmark (use a bookmark specially created for this and the       replace bookmark action)     
• On sheet de-activate, replace the selections made on the sheet with the bookmark.
• If you want the special sheet selections to remain, use another bookmark with the reverse of the above on the triggers

Hope this helps,

Hirish