topic Re: Average Calculation in QlikView

Average Calculation

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

Hi ,

i Have Below data

Dimension : Month

Expressions : Efficiency , Running Machine, Quality Rate

Got the below format Chart object by a pivot Table by moving Dimension column Horizontally.

But not have and option to get the Yellow Highlighted Average/total Column.

1.1 Average Efficiency of all Months

1.2 Total Running Machines of all the months

1.3 Average Quality Rate of all months

Please Help???

MayilVahanan — Tue, 16 Mar 2021 08:38:28 GMT

You can refer the below link

nuwanhwb87 — Wed, 17 Mar 2021 00:29:32 GMT

Hi ,

how do i get this.

Is it a seperate query or????

Can you please explain further