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?