Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Partner
Partner

Qlik Sense Set Analysis Percentage Calculation

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.

1 Reply
sinanozdemir
Valued Contributor III

Re: Qlik Sense Set Analysis Percentage Calculation

Hi Joshua,

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

Capture.PNG

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

Capture.PNG

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

Thanks