topic Re: How to show Average of Rows in Pivot Table in QlikView

How to show Average of Rows in Pivot Table

SatyaPaleti — Sat, 16 Nov 2024 20:55:15 GMT

Hi Friends,

Could some one guide me. How can we show a Average of Rows in Pivot Table.

I am having a data on Daily, Weekly & Monthly and Qty as a Metrics. I am showing data like in below format.

Currently it is showng Sum of rows but I want to show Average of Rows. Average of both Jan & Feb Qty.

Note: In Month level I want to show Sum but in Total I want to show Average.

Same process for Weekly & Daily also. Could some one please help me on this. Please find attached documents for Sample qvw & Sample Data.

Thanks and Regards,

Satya

Re: How to show Average of Rows in Pivot Table

jaibau1993 — Wed, 08 May 2019 06:29:20 GMT

Hi Satya!

You can solve this issue using dimensionality and secondarydimensionality functions to write a diferent expression for "normal" cells and "total" cells. Please, see the attached file where I modified your expression!

Bests,

Jaime.

Re: How to show Average of Rows in Pivot Table

SatyaPaleti — Wed, 08 May 2019 12:47:15 GMT

Hi Jamie,

Thank you so much for your response. Could you please suggest how can we show the exact average for Total?. Total average is Missing

Thanks and Regards,

satya

Re: How to show Average of Rows in Pivot Table

jaibau1993 — Wed, 08 May 2019 13:43:37 GMT

Hi Satya!

What do you mean by "Total average is Missing"? In my qvw document there are no missing values!

Otherwise, I realiced that the grand total was not correct (it was not the average of months totals!). I attach the corrected file.

Regards,

Jaime,