Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Each Values difference with %

Hi

I have 1 measures Sum(total) and 1 Dimension (Year).

I line chart i have to display X-Axis my year like 2011,2012,2013,2014....

Y axis should be sum(total) but i have to display only difference % e.g  (2012 sum minus 2011 sum divided by 2011 sum).

Is there any default function available like rollup sum,difference %,difference % only selected.

Thanks

Govind R

1 Reply
sunny_talwar

May be like this:

(Sum(total) - Above(Sum(total)))/Above(Sum(total))