Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Specialist
Specialist

Difference between two values of a dimension

In my pivot table I have two dimensions as a columnheader.

First dimension is year, second is a calculated dimension.

I want to calculate the difference between two years as a percentage.

$(vmaxyear) is the most recent yearvalue (not calander-year)

So I have an expression like this :

for current year :  count({<year=('=$(vmaxyear)')>}employees)

for previous year  count({<year=('=$(vmaxyear)-1')>}employees)

but that does not seem to work. Because the second dimension doesn't always has the same number of columns, I can not use something like before() or below()

 

Labels (2)
0 Replies