Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a master data table with a hierarchy of budgets.
I have been try to demonstrate distribution structure on pie chart as shown in the screen.
I have tried set analysis to calculate sum of budget pieces, but unsuccessfully .
Appreciate if someone could help on this.
Create a pie chart with no dimension and three expressions:
Thanks, but i need a little more help It is clear only for these specific values (one parent, two systems). And what about there are many objects with different systems and parents. How can i define set analysis without specific system/parent values?
You can't. There has to be a link between systems and parents. All records of the same 'family' need an identifier that uniquely identifies the family. Perhaps you can remodel your data using the hierarchy function.
You didn't mention that before. I can't read minds so I don't know anything about your data if you don't tell me. If you used the hierarchy function you should already have the fields you need. Perhaps you can post a qlikview document with the data so somebody can create a solution for you.