2 Replies Latest reply: Sep 12, 2017 3:41 AM by daniel melo RSS

    Set analysis over variables in QlikSense

    daniel melo

      Is it possible to do a set analysis to a variable?

      I have a variable called vSOM with something like:



      (Sum([MyVolume: Prod1]+[MyVolume: Prod2]))


      (Sum([Industry Volume: Prod1]+[Industry Volume: Prod2]))

      Now, what I want is to have a YoY:



      (Sum({<Year={'2017'}>}$(vShareofMarket)) - Sum({<Year={'2016'}>}$(vShareofMarket))) - 1

      Is this possible to perform? Or should I have to create one variable for actual year and another one for previous year and operate over them?