Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Block Chart Subtotal Aggregation Type?

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.

Block Chart Totals.jpg

4 Replies
sunny_talwar

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

Not applicable
Author

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

Robby

sunny_talwar

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.

Not applicable
Author

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.

BlockSample.jpg