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

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
Gysbert_Wassenaar

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
reddy-s
Master II
Master II

Hi Parrish,

Is it possible to share a sample QVF?

Thanks,

Sangram.