Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to deal with Percentages in PivotTable ...

... instead of rolling up the the different levels in Pivot table results are summed on each level.  For example if I have value (.092) aka 92% or (92) aka 92% at the next group level results are added together instead of a Median rollup. 

2 Replies

Re: How to deal with Percentages in PivotTable ...

If you want to do a sum of median averages then you need to nest aggregation functions. You need the aggr function for that: sum(aggr(avg(MyValue), MyDim1, MyDim2, ..., MyDimN)). Replace avg(MyValue) with your current expression and replace MyDim1, MyDim2, ..., MyDimN with the dimensions of your pivot table.


talk is cheap, supply exceeds demand
reddys310
Honored Contributor II

Re: How to deal with Percentages in PivotTable ...

Hi Parrish,

Is it possible to share a sample QVF?

Thanks,

Sangram.

Community Browser