0 Replies Latest reply: Aug 1, 2017 3:19 AM by Mahidhar Alapati RSS

    Trying to show Daily and Monthy Comparison between Current Year and Previous Year in a Pivot table in QlikSense

    Mahidhar Alapati

      Hi All,

       

      I am trying to show Daily and Monthy Comparison between Current Year and Previous Year in a Pivot table in QlikSense.

      We have all the Calendar fields (Date, Month, Year, Month-Year etc) in a dimension called DimDate. We have a Fact table storing the transactions. Date is common between DimDate and Fact.

       

      I tried to show the following in Pivot table and did not succeed.

       

      Month-Year

      Date

      Turnover

      Turnover Last Year

       

      I tried using set analysis, but did not succeed as the date related tables are present in the chart.

      Is there a way do it?

      Below is an example of How it should look like.


          

      MonthDateMachine TurnoverMachine Turnover Last yearVariance
      Jan-2017$10,754,608$10,753,452$1,156
      Feb-2017$9,331,047$9,522,667-$191,620
      Mar-2017$11,239,822$10,111,051$1,128,771
      Apr-2017$10,341,098$10,613,375-$272,276
      May-2017$11,166,579$9,722,408$1,444,171
      Jun-2017$7,142,170$10,197,236-$3,055,067
      (when expanded to date)01/06/2017$370,590$276,170$94,420
      02/06/2017$829,450$601,126$228,324
      03/06/2017$1,250,095$1,048,779$201,316