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: 
marcobombo
Contributor
Contributor

Previuos year and calcultion of index in pivot table

Hi,

I have two problem with the pivot table and set analysis.

First: I would like to calculate the percentage difference of a value based on the previuos year. I use the above, but when I select only one year the expression doesn't work. Any idea?

Second: I need to calculate the index on the basis of one year (2000) and with the Set Analysis works, the problem is that when I choose different years since 2000, however, showed me the value 2000 in dimension. Any idea?

I attache the example.

Thanks

0 Replies