Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
usually I compare a group of companies against another single company within a sector.
In the attached example I do compare A and B as the group against H.
On this account I have created a chart with the corresponding company dimensions in the set analysis.
What I wanna do now is to examine the data within a sector on corporate group level with the same target of
comparing groups. Hence, I have aggregated the data in the load script.
My problem now is that in my original qlikview document many analysis including the set analysis on company level are implemented.
Is there any way to map or use an if clause to switch between the two levels without changing all expressions in the chart.
Like when choosing the corporate group level, this substitutes the company field.
So for the attached example, leave the chart unchanged. Now I would like the aggregated values of group 1 and as peer group 2 compared in the chart.
I hope I made myself clear.
Many thanks in advance!
Thank you