Qlik Sense Set Analysis Percentage Calculation

[jcampbell]

Thought I would share an expression I created today to calculate the percent change in sales from this year over the previous year. Using Set Analysis I was able to achieve exactly what I needed with the following:

Num(Sum({<[Year]={'2015'}>} [Sales]) - Sum({<[Year]={'2014'}>} [Sales])) / Sum({<[Year]={'2014'}>} [Sales])

I hope you find this helpful.

[sinanozdemir]

Hi Joshua,

You can also use set analysis to dictate the previous year, look at the below example:

The below expression is what I used in the text box:

Dynamic variables/values are way better than hard-coded ones.

Thanks