topic Group within a Group? in QlikView

Group within a Group?

danielact — Wed, 22 Jun 2011 17:36:05 GMT

I have a report that uses a drill-down group. I was asked to replace one of the fields in the drill-down with a choice of three. If it was only those three, with nothing before or after it, I'd just set up a cyclical group. Is there a way to set up a cyclical group to be used as an element within a drill-down?

Group within a Group?

kaushiknsolanki — Wed, 22 Jun 2011 18:04:27 GMT

Hi,

Its not possible to have group within group.

I dont know is this meet your requirement or not, but if you have only one expression in chart then you can use the two dimension. one as cyclic and other as drill down.

regards,

Kaushik Solanki

Group within a Group?

danielact — Wed, 22 Jun 2011 18:26:23 GMT

I have a lot of expressions in the chart, and I don't want to have the full split by each one. I want to have the drill down go Level A --> Level B --> Choice of [C1, C2, C3] --> Level D

Group within a Group?

kaushiknsolanki — Wed, 22 Jun 2011 18:44:10 GMT

Hi,

Is C1, C2, C3 Are fields.

Regards,

Kaushik Solanki

Group within a Group?

danielact — Wed, 22 Jun 2011 18:45:42 GMT

Yes, they are fields. I'd put them in the drill-down separately, but I don't want to have to filter one to get to the other.

Group within a Group?

kaushiknsolanki — Wed, 22 Jun 2011 19:05:32 GMT

Hi,

No its not possible to implement group within group.

Regards,

Kaushik Solanki

Group within a Group?

Wed, 22 Jun 2011 20:43:13 GMT

I just posted this in response to another question but thought it may be helpful here also with a little tweaking:

You can add calculated dimensions to a cyclical group. Just click the 'Add Expression' button under the 'Used Fields' box in the Group Settings box.

dimension 1: Level A

dimension 2: Level B

dimension 3: if(Level C= 1, 1, null())

dimension 4: if(Level C= 2, 1, null())

dimension 5: Level D

Then in your dimension settings check the 'Suppress if value is null' box to limit it to show only those values for the appropriate Level C.