1 Reply Latest reply: Oct 20, 2015 4:29 PM by Sinan Ozdemir RSS

    Qlik Sense Set Analysis Percentage Calculation

    Josh Campbell

      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.