0 Replies Latest reply: Dec 1, 2015 12:23 AM by Rahul Pandhe RSS

    QlikSense Set Analysis/ Dense Rank like function

      I have following data:

      OrderNum, OrderDate, OrderTotal

      XYZ, 01/01/2014, $300

      JJJ, 01/01/2014, $175

      SDS, 01/03/2014, $500  ( note 01/02/2014 is missing)

      DJD,01/04/2014, $800

      XYZ, 01/01/2014, $100

      SDS, 01/02/2015, $1100  ( note 01/02/2014 is missing)

      DJD,01/04/2014, $200

       

      I wat to rank as follows, by order date year.

       

      Rank, OrderNum, OrderDate, OrderTotal

      1, XYZ, 01/01/2014, $300

      1, JJJ, 01/01/2014, $175

      2, SDS, 01/03/2014, $500  ( note 01/02/2014 is missing)

      3, DJD,01/04/2014, $800

      1, XYZ, 01/01/2015, $100

      2, SDS, 01/02/2015, $1100  ( note 01/02/2014 is missing)

      3, DJD,01/04/2014, $200

       

       

      Basically I want to give serial sequence number to all the unique dates and chart them on X axis and Y axis being the sum with two lines one for 2014, and another for 2015.

       

      Basically  a time comparision chart of daily sales.

       

       

       

      Any way to do this in QlikSense?