topic Re: [ASK] Drill-down Group in Cyclic Group in QlikView

[ASK] Drill-down Group in Cyclic Group

Tue, 11 Feb 2014 08:55:07 GMT

Hello qlikview user..

i want to ask that can i create a Cyclic Group that have Drill-down Group also for dimension?

example :

Main dimension is Cyclic Group that have :

1. State

2. Province

3. Branch

and Branch is a Drill-down Group that have :

1. Area

2. City

Many thx before

Re: [ASK] Drill-down Group in Cyclic Group

vikasmahajan — Tue, 11 Feb 2014 09:41:04 GMT

PFA sample

Vikas

Re: [ASK] Drill-down Group in Cyclic Group

Wed, 12 Feb 2014 06:22:12 GMT

thx for your reply Vikas,

but this is not what i mean..

what i want is that i select Branch in my cyclic group dimension then it can drill down, but when my cyclic group isn't selecting branch then there's no drill down group.

Re: [ASK] Drill-down Group in Cyclic Group

Wed, 12 Feb 2014 06:32:47 GMT

Hi,

Not sure if I understand you exactly, but if you mean you need to have a drill down group inside a cyclic group (Both in a single column) then I don't think that is possible.

But if you need cyclic and drill down group in as 2 separate columns then once "Branch" is selected in cyclic group then there should be some particular selection in drill down group. This i think can be achieved using field based triggers.

Re: [ASK] Drill-down Group in Cyclic Group

Wed, 12 Feb 2014 06:35:17 GMT

sorry for my bad english..

what is field based triggers and how to use it?

Re: [ASK] Drill-down Group in Cyclic Group

Wed, 12 Feb 2014 06:44:26 GMT

I am assuming you need the second scenario i.e Cyclic and Drill down in 2 separate columns and selections in drill down based on cyclic group.

For field based triggers, go to Settings--Document Properties, Triggers tab and follow the below steps:

1. In the "Field Event Triggers" section, select the field you want the selection to happen, in your case I think it will be "Branch".

2. Click on Add Action per your need i.e. OnSelect, OnChange, OnLock or OnUnlock.

3. Add Action as,

Action Type: Selection
Action: Select in Field

This way you can make selections in the field you want based on the field selected in Cyclic Group.

Hope this helps!