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.

       

      Thanks.