topic Re: Child Distribution on pie chart in QlikView

Child Distribution on pie chart

Anonymous — Mon, 16 Feb 2015 01:56:15 GMT

Hi,

I have a master data table with a hierarchy of budgets.

BudgetUID	Name	ParentBudgetUID	javascript:;Sum
1	General	-	1000
2	System 1	1	150
3	System 2	1	100

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.

Re: Child Distribution on pie chart

Gysbert_Wassenaar — Mon, 16 Feb 2015 09:21:04 GMT

Create a pie chart with no dimension and three expressions:

Not distributed: sum([javascript:;sum]) - sum({<PartentBudgetUID={1}>}[javascript:;sum])

System 1: sum({<Name={'System 1'}>}[javascript:;sum])

System 2: sum({<Name={'System 2'}>}[javascript:;sum])

Re: Child Distribution on pie chart

Anonymous — Mon, 16 Feb 2015 09:54:37 GMT

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?

Re: Child Distribution on pie chart

Gysbert_Wassenaar — Mon, 16 Feb 2015 10:02:00 GMT

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.

Re: Child Distribution on pie chart

Anonymous — Mon, 16 Feb 2015 10:06:26 GMT

But i have all the fields generated by 'Hierarchy' function such as UID, ParentUID, NodeName, Depth.

Re: Child Distribution on pie chart

Gysbert_Wassenaar — Mon, 16 Feb 2015 10:13:25 GMT

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.

Re: Child Distribution on pie chart

Anonymous — Mon, 16 Feb 2015 10:53:17 GMT

sorry

See in attachment for example and preferred result.

Re: Child Distribution on pie chart

Gysbert_Wassenaar — Mon, 16 Feb 2015 11:34:43 GMT

See attached qvw.

Re: Child Distribution on pie chart

Anonymous — Mon, 16 Feb 2015 14:00:20 GMT

Thank you very much. But i can't modify it to bar chart as i need. If i add new dimensions (period, name1, name2) it became incorrect.