0 Replies Latest reply: Oct 9, 2018 3:26 AM by Rachana Jannapureddy RSS

    YOY,MOM calculations in qliksense

    Rachana Jannapureddy

        Could you please guide me on calculating MOM,YOY,Monthly GAP in the pivot table???  

      Region countryDateValues
      NAUS12/1/2017100
      NAUS13/2/2017200
      NAUS14/3/2017300
      NAUS5/4/2017400
      NAUS11/5/2017500
      NAUS20/6/2017600
      NAUS23/7/2017700
      NAUS25/8/2017800
      NAUS19/9/2017900
      NAUS19/10/20171000
      NAUS15/11/20171100
      NAUS17/12/20171200
      NAUS10/1/20181300
      NAUS11/2/20181400
      LAMArgentina12/1/20171500
      LAMArgentina13/2/20171600
      LAMArgentina14/3/20171700
      LAMArgentina5/4/20171800
      LAMArgentina11/5/20171900
      LAMArgentina20/6/20172000
      LAMArgentina23/7/20172100
      LAMArgentina25/8/20172200
      LAMArgentina19/9/20172300
      LAMArgentina19/10/20172400
      LAMArgentina15/11/20172500
      LAMArgentina17/12/20172600
      LAMArgentina10/1/20182700
      LAMArgentina11/2/20182800