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:

       

      vShareofMarket=

      (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?


      Thanks