topic Dates sorting within chart in QlikView

Dates sorting within chart

alisonpwallis — Tue, 09 Sep 2014 14:24:56 GMT

I have a chart showing cumulative records for two years. I want the y axis to show (in order) the week concerned and the year:

e.g.

01 2012

02 2012

03 2012

I have a field called Application Date which contains the date information for each record. I've tried creating a calculated dimension: =week([Application Date])&year([Application Date])

but this won't seem to sort and i get a random order of values.

Can anyone help?

Thanks

Alison

Re: Dates sorting within chart

JonnyPoole — Tue, 09 Sep 2014 14:27:48 GMT

try convert it to a numeric like this: =Year*100 + week(Date)

This will give you a number that is easy to sort chronologically 201401, 201402 etc...

Use it as the dimension or just a sort order of 'expression'

Re: Dates sorting within chart

Gysbert_Wassenaar — Tue, 09 Sep 2014 14:32:06 GMT

Try creating it as: dual(week([Application Date])&year([Application Date]), [Application Date])

Re: Dates sorting within chart

MarcoWedel — Tue, 09 Sep 2014 14:44:05 GMT

dual(week([Application Date])&' '&year([Application Date]), WeekStart([Application Date]))

to get only one value at the axis for all dates within this week