Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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?