Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

satyapaleti
Contributor II

How to show Average of Rows in Pivot Table

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.

Monthly.JPG

 

 

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

 

 

 

3 Replies
Highlighted
Partner
Partner

Re: How to show Average of Rows in Pivot Table

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.

satyapaleti
Contributor II

Re: How to show Average of Rows in Pivot Table

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

Partner
Partner

Re: How to show Average of Rows in Pivot Table

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,