Cyclic Group Inside a Cyclic Group in QLikSense

[Ratier]

Hi there!

I have a question, if someone could help me i'd be very greatful

I have a 3 level hierarchy data like this:

• SOMETHING: Includes group "Responsáveis" and other groups that i still need to create
• RESPONSÁVEIS: Is also a group, within "Something".  that has, inside it, the group "Mina" and "Porto" and each one of them has it's values.

Since, for now, "SOMETHING" dos only have a group within it, i have something like this

Using the code below and a drill-down group with Responsáveis>Causas I can produce the following dynamic pie chart:

If(Match(Causas, 'PORTO1','PORTO2','PORTO3')>0, 'Porto', 'Mina') as "Responsáveis"

I need to put the entire "Responsáveis" group inside the "Something" group to produce the dynamic pie chart below:

How can I do this? 

[ogster1974 · Accepted solution]

Have you looked at the Alternate Dimensions capability to switch context of your Pie Chart?