Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
mattcorke
New Contributor II

Most recent minus previous in pivot table total column

Hi there,

I have a pivot table that looks like this. I would like to add two totals column that calculates the difference between the most recent effort / attainment grade and the previous  / attainment effort grade.

For example:

Business December effort = 4

Business September effort = 5

Total column (Most recent - previous) = -1

Ideally, if only certain dates were selected then the calculation would update to reflect the selected dates. E.g. if September and March 2018 were selected then most recent date used would be September (despite more recent dates existing in the data) and the previous date used would be March 2018.

How could I do this?

Many thanks,

Matt

 

Most recent minus previous calculation.jpgEffort and attainment