Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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:

image.png

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

image.png

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 (4)
0 Replies