topic Taking Average in QlikView

Taking Average

nuwanhwb87 — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

Need to get the KPI wise Average/Total as per the Above format.

Please help

Re: Taking Average

edwin — Mon, 25 Jan 2021 15:52:21 GMT

add the AVG/TOTAL as an aggr in the dimension, then your normal expression. make your pivot fully expanded:
dim: KPI, MONTH, =num(aggr(Avg(Val),KPI)/aggr(sum(Val),KPI),'#.##%')

Re: Taking Average

edwin — Mon, 25 Jan 2021 15:53:16 GMT

this is assuming you wanted the average per KPI/total per KPI

Re: Taking Average

nuwanhwb87 — Tue, 26 Jan 2021 14:16:24 GMT

Noted with thanks.

In My Above Format Dimension is the Month , Other KPI's are Calculated Expressions.

I'm not Clear. Please explain further

Re: Taking Average

edwin — Tue, 26 Jan 2021 14:52:46 GMT

of course you also have KPI as dimension (per your pic) not just month. what i am saying is that aggregation is by KPI (total grouped by KPI)