7 Replies Latest reply: Aug 16, 2016 10:04 AM by Shekar k RSS

    Need help to calculate YTD in Qliksense Pivot

    Shekar k

      Hi, I am new to Qliksense. Need some logical help to calculate the YTD values of a sales module Plan and Actual like below,

       

               

      Apr-16May-16Jun-16YTD Jun-16Achivement %
      Sales PlanActualsSales PlanActualsSales PlanActualsSales PlanActuals
      India1,0009892,0001,7003,0003,0006,0005,689105%
      ME1,2001,2342,0001,7003,0003,0006,2005,934104%
      UK/Europe1,0009892,0001,7003,0003,0006,0005,689105%
      US1,0009892,0001,7003,0003,0006,0005,689105%
      Australia1,0009892,0001,7003,0003,0006,0005,689105%
      Grand Total5,2005,19010,0008,50015,00015,00030,20028,690105%

       

      I am able to calculate the everything except YTD column. Please help.