Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
MVP
MVP

Re: Each Values difference with %

May be like this:

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