Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

johan_joubert
New Contributor

HOW TO AGGREGATE PIVOT TABLE COLUMNS BY AVERAGE

Hi Everyone,

Hope one of you could maybe help in this regard. I have a pivot table in which the columns are aggregated by SUM, but I want them to aggregate by Average on each respective level. Also, something to note, the “utilisation %” measure is wrapped in a variable called vUtilisation – can I use a variable inside an Aggr function?

Pivot Table.jpg

I tried the following, but to no avail:

Avg(Aggr(Sum(vUtilisation),cf_business_line, cf_practice, CO_EM, Resource_Name, Project))

Any help will really be appreciated.

Thanks.

Tags (2)
1 Reply
johan_joubert
New Contributor

Re: HOW TO AGGREGATE PIVOT TABLE COLUMNS BY AVERAGE

So any chance anyone knows how to use a variable inside an aggregation function?