5 Replies Latest reply: Aug 10, 2015 10:59 AM by Sinan Ozdemir RSS

    QlikSense - current month data vs previous month

      Hello,

      I am trying to create a sheet to display difference between previous month and current month data amounts.

      So far I have tried to get amount difference for current month but no luck. Ideally I should get amount difference for every month.

      My script is as follows (see attached project also):

       

      sum({1<Date = {">=$(=monthstart(Today()))<=$(=monthend(Today()))"}>}Amount) - sum({1<Date = {">=$(=monthstart(AddMonths(Today(), -1)))<=$(=monthend(AddMonths(Today(), -1)))"}>}Amount)

       

      but it gives me incorrect results. Any Ideas?