Activate sheet based on a selection in the drill down group

[#1]

Hi All,

I have a drill down group - Period (Year-->Quarter-->Month-->Week) in sheet 1...When the user selects a value in the week during drill down, sheet 2 should be activated...Week filter will be available in all sheets...So I shouldn't apply field event trigger...

Please share your ideas to acheive this

[#2]

Hi,

In the sheet properties set a condition checking that what needs to be selected is selected.
In attach example if you select productkey an extra shets appears

Regards

[#3]

Thanks for your quick reply...

But in my case, all sheets should be displayed at all time...

When the user selects a value in the week, it should navigate to the sheet 2 which will contain the detailed charts for the selected week

[#4]

Just as easy I guess.
Set an action behind the field trigger 'OnSelect' (via document properties) where set activate sheet.

See example. If yous select now you go to sheet1

[#5]

That is correct...But that field will be available in other sheets also...This field event trigger will be trigered if we select a value in that field irrespective of the sheet or group....So this won't be applicable...

[#6]

mmm;, indeed a bit harder. CLosest I get is by setting an action 'Deactivate Object' in the sheetproperties/ triggers

But the after selecting  the user clicks anyware and goes to the forseen sheet.
This one is then also only valid on that sheet.

If that's not good enough I think you will need to program a macro to do it.

[kaushiknsolanki · Accepted solution]

Hi,

   Have a look at the attached example.

   Hope this is what you want.

Regards,

Kaushik Solanki

[#8]

It works as expected...Thank you Kaushik

[#9]

Hi Kaushik,

I can't open your file, due to my Qlikview version, but I'm interested in the method you use.

In my case, I'd like to activate a sheet when a specific field is selected in the previous sheet.