Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jcampbell
Partner - Creator
Partner - Creator

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
Specialist III
Specialist III

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