topic Re: Block Chart Subtotal Aggregation Type? in QlikView

Block Chart Subtotal Aggregation Type?

Thu, 25 Aug 2016 20:55:16 GMT

Is it possible to change the aggregation type for the header row of the block chart when you have 2 dimensions? Right now it looks like its just summing the expression. This is a problem when the expression is an Average and I want the total aggregation to be an average as well.

Re: Block Chart Subtotal Aggregation Type?

sunny_talwar — Fri, 26 Aug 2016 00:13:22 GMT

Have you already tried using Dimensionality() or Aggr() function to get this resolved?

Re: Block Chart Subtotal Aggregation Type?

Fri, 26 Aug 2016 00:26:07 GMT

I haven't yet but do you have an example of what it might look like?

Robby

Re: Block Chart Subtotal Aggregation Type?

sunny_talwar — Fri, 26 Aug 2016 08:33:57 GMT

In general -

Dimensionality:

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

Aggr():

https://www.analyticsvidhya.com/blog/2014/02/aggr/‌

Particularly for your example it would be helpful if you can provide a sample, even dummy data will work, but a sample with expectation of an output will be very helpful in getting you to your final result.

Re: Block Chart Subtotal Aggregation Type?

Fri, 26 Aug 2016 17:46:29 GMT

In its simplest form if you look at the picture I posted where it shows 180,194. I want this to be an avg instead of a sum.

If I gave you a data set that had

Apple Green 2

Apple Red 4

Orange Red 5

Orange Orange 10

The total field should show 3 instead of 6 for Apple and 7.5 for Orange instead of 15. Currently the total will only SUM the expression which is a problem if the expression is an average.