topic Sum of Rows on Count expression in Pivot Table in QlikView

Sum of Rows on Count expression in Pivot Table

Tue, 24 Jun 2014 19:16:51 GMT

I need a way to get the sum of rows of my expression on the bottom of the pivot chart. At it's most basic it is just a count distinct expression with a little set analyisis.

I have looked on these forums and found a lot of comments about using aggr(function , dim1, dim2 ), but when I use this, the total is blank,

Any help would be appreciated !

Thanks,

Kevin

Re: Sum of Rows on Count expression in Pivot Table

swuehl — Tue, 24 Jun 2014 19:22:26 GMT

Yes, using advanced aggregation might be the way to go, look also in the Help for 'sum-of-rows in a pivot table using advanced aggregation'. You may just need an outer aggregation function:

=sum( aggr( function, dim1, dim2))

e.g.

=sum( aggr( count(Distinct Customer), Customer, Country))

Re: Sum of Rows on Count expression in Pivot Table

Tue, 24 Jun 2014 19:49:12 GMT

The additional aggregational sum feature worked. Thanks swuehl