0 Replies Latest reply: Mar 2, 2018 7:48 AM by Anand kumar RSS

    YTD calculation

    Anand kumar

      Hi

       

      How to get YTD in Straight table as an additional measure  along with Monthly sales measure in Qliksense

      To Detail:

      I have Data like

      Yearmonth, Volume, Client name, product type

      attached has the sample data and I want to calculate YTD and the pct difference along with the last 13 months volume

      was able to use set analysis to get the sum for YTD but when I add that in pivot that is getting split by Year month  like below

       

      Cname ,                                          year month                                            YTD

                                   Jan 2017|Feb 2017|.....|Jan 2018|Feb 2018    Jan 2017|Feb 2017|.....|Jan 2018|Feb 2018

      Arun                         10 |20.....|30|40                                                       10 |20.....|30|40

      Asha                         30 |40.....|20|10                                                       30 |40.....|20|10


      Can some body help me out to get the YTD and pct difference as Given in the excel


      Thanks for all your help ahead





      Regards,

      mhappiee