2 Replies Latest reply: Jul 31, 2012 8:48 AM by ramkumar24 RSS

    Need help with expression

      I have to show the data in pivot table in my QlikView report as shown below


      Period          Amount


      4/1/2012          360

      5/1/2012          1000

      6/1/2012          1500



      The actual amount values for period

      5/1/2012 is 640 and for 6/1/2012 is 500.

      To make it possible (ie. current period amount + previous period amount), I am using expression

      =sum(Amount) + sum( {$<Period=$(vPrevMonth)>} Amount)


      and vPrevMonth is calculated as addmonths(Period,-1)


      Not sure my approach is right or not, but somehow the expression is not working. Please suugest the way to achieve this in QlikView.