topic Re: Qlikview Navigation help in QlikView

Qlikview Navigation help

Sat, 09 Jan 2016 09:41:08 GMT

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

Re: Qlikview Navigation help

Chanty4u — Sat, 09 Jan 2016 10:12:09 GMT

use show hide objcts

Re: Qlikview Navigation help

Sat, 09 Jan 2016 10:53:56 GMT

Hi Suresh,

Thanks for reply.

Can you attach sample QVW?

Thanks,

QV11 User

Re: Qlikview Navigation help

maxgro — Sat, 09 Jan 2016 10:55:07 GMT

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

Re: Qlikview Navigation help

sfatoux72 — Sat, 09 Jan 2016 11:16:47 GMT

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.

Re: Qlikview Navigation help

HirisH_V7 — Sat, 09 Jan 2016 11:20:35 GMT

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