Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
New Contributor

Pivot Table and general Average

Hi Experts

Someone can support me as I can solve the following question.

I have a pivot table with the transactions per day and even the average side, the drawback is that this average is giving me per day and what I need is that in each day I show the total average.

captura1.PNG

currently this is the formula.

2 Replies
Highlighted
New Contributor III

Re: Pivot Table and general Average

hi,

Sample Data:

clipboard_image_0.png

 

Result :

clipboard_image_1.png

Set for Dim in Row:

clipboard_image_2.png

Set Column:

clipboard_image_3.png

set measure:

clipboard_image_4.png

Try this, you will have result

 

K. Srinivasan

Highlighted
Valued Contributor II

Re: Pivot Table and general Average

Try Using the AGGR Function