Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 

Average in same measure in pivot table

Hi there!

I am using a pivot table to show the 'how many' from something sorting by diferent dimensions.

The problem comes when I'm trying to make a pivot table with the average of this count by months. I mean, the average of a month with the immediate before.

The expression I would like to do is this: (count(portfolio) + before(count(portfolio) /2) with no results. Actually I have the results I want but the issue is that in the first column it doesn't show properly the numbers because in the first column there are no 'before data'

It is something like that:


And when I expand the year it doesn't show data in the others years:


I've seen another problem and it is that if any dimension is moved, the expresion doesn't work.image.png

Any idea to solve this? 


Thank you!

Labels (2)
0 Replies