topic Ordering Dates in QlikView

Ordering Dates

johnso2080 — Wed, 27 Feb 2013 15:53:43 GMT

Hello,

I want to create a trend graph showing a weeks sales by date for this year, and the same equivalent week last year. I have data that is (basically)...

Date	Sales (TY)	Sales (LY)
1 Feb 2012		120
2 Feb 2012		130
3 Feb 2012		140
4 Feb 2012		150
5 Feb 2012		160
6 Feb 2012		170
7 Feb 2012		180
3 Feb 2013	210
4 Feb 2013	220
5 Feb 2013	230
6 Feb 2013	240
7 Feb 2013	250
8 Feb 2013	260
9 Feb 2013	270

In the chart I'm using a dimension that shows each date in the format 'dd MMM' so that the years overlap, so it should look like...

But in qlikview the dates appear in the wrong order on the x-axis. I can't sort them by date because, for example, 9 Feb last year occurs before 1 Feb this year.

Can anyone offer any advice?

Thanks

Darren

Re: Ordering Dates

johnso2080 — Wed, 27 Feb 2013 15:55:13 GMT

(missing image)

Re: Ordering Dates

Anonymous — Wed, 27 Feb 2013 16:15:48 GMT

Darren,

You need to create a year-independent "date" in your calendar, and use it in the chart. To keep it in a valid date format, just use any year. In the example here I use year 0 (as good as any):

date(MakeDate(0, month(Date), day(Date)), 'DD MMM') as ChartDate

Regards.

Michael