topic Re: Qlik Sense Set Analysis Percentage Calculation in QlikView

Qlik Sense Set Analysis Percentage Calculation

jcampbell — Tue, 20 Oct 2015 16:54:53 GMT

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.

Re: Qlik Sense Set Analysis Percentage Calculation

sinanozdemir — Tue, 20 Oct 2015 20:29:18 GMT

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