topic Re: Activate sheet based on a selection in the drill down group in QlikView

Activate sheet based on a selection in the drill down group

Fri, 15 Jul 2011 05:29:35 GMT

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

Re: Activate sheet based on a selection in the drill down group

Fri, 15 Jul 2011 05:38:49 GMT

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

Activate sheet based on a selection in the drill down group

Fri, 15 Jul 2011 05:44:54 GMT

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

Re: Activate sheet based on a selection in the drill down group

Fri, 15 Jul 2011 05:50:34 GMT

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

Activate sheet based on a selection in the drill down group

Fri, 15 Jul 2011 05:56:12 GMT

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...

Re: Activate sheet based on a selection in the drill down group

Fri, 15 Jul 2011 06:18:28 GMT

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.

Re: Activate sheet based on a selection in the drill down group

kaushiknsolanki — Fri, 15 Jul 2011 06:19:19 GMT

Hi,

Have a look at the attached example.

Hope this is what you want.

Regards,

Kaushik Solanki

Activate sheet based on a selection in the drill down group

Fri, 15 Jul 2011 06:59:23 GMT

It works as expected...Thank you Kaushik

Activate sheet based on a selection in the drill down group

Mon, 22 Aug 2011 09:25:50 GMT

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.