Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Elliot2
Contributor
Contributor

Dynamic KPI change in %

Hi

I´m seeking a dynamic formula to visualize the change over time in %. Right now I have the KPI manually written by taking the (new value - old value) / old value. I want the KPI to be dynamic. If I sort by for example, year, I want the KPI to change to the change in % for that year. How would a formula for that be?

Thanks, Elliot! 

Labels (2)
1 Reply
Chanty4u
MVP
MVP

May be this ?.

(Sum({<Year = {$(=Max(Year))}>} Sales) - Sum({<Year = {$(=Max(Year)-1)}>} Sales)) / Sum({<Year = {$(=Max(Year)-1)}>} Sales)