topic Re: Aggregation Help in Chart in QlikView

Aggregation Help in Chart

pkpandey — Sun, 03 Apr 2016 09:03:01 GMT

Hi All

I need help in a chart where I have to show the value and percentage of value on group total. I have attached the sample file. Presently percentage is showing only on 3 rows.

Re: Aggregation Help in Chart

mithilesh17 — Sun, 03 Apr 2016 10:01:21 GMT

Hi,

Kindly check my solution.

Hope that helps.

Regards,

Mithilesh

Re: Aggregation Help in Chart

pkpandey — Sun, 03 Apr 2016 10:25:51 GMT

But all the items not showing in the charts.

Regards

PKP

Re: Aggregation Help in Chart

sunny_talwar — Sun, 03 Apr 2016 10:40:20 GMT

I would steer you away from Aggr() function as they take a toll on performance. You can try this expression:

Sum(Value)/Sum(TOTAL <Group>Value)

Re: Aggregation Help in Chart

sunny_talwar — Sun, 03 Apr 2016 10:43:32 GMT

For the chart, you can try this:

Sum(Value)/Sum(Aggr(Sum(TOTAL <Group> Value),Group, Item))