3 Replies Latest reply: Oct 23, 2015 11:33 AM by Sunny Talwar RSS

    How to convert Set Analysis make it able to dynamic on date ?

    Yeo Poh sai

      Hi All



      Marcus have help me with the below script , which work fine for Qlik Sense because in QS it does not encourage user to select month and year.


      LY YTD =

      sum({$<eXP={'eXP'}, date={">=$(=num(AddYears(YearStart(Today()), -1)))<=$(=num(AddYears(Today(), -1)))"}>} Amount)


      YTD =


      sum({$<eXP={'eXP'}, date={">=$(=num(YearStart(Today())))<=$(=num(Today()))"}>} Amount)



      Now i want to implement the similar script in Qlik View , which allow user to select month and year.



      I hope some one can help me convert the above script into more dynamic script , which allow to allow user change the month and year. Meaning can select month =12 and year = 2013 for view the sales change from 2012 to 2013.