Month Year

[#1]

Hi guys

I got MonthYear in a spreadsheet and it runs like this:

But qlikview reads it and sorts it like this:

Any idea how to resolve this? i tried taking the sorting off but it doesnt help.

Any input would be much appreciated.

[#2 · Accepted solution]

Hi,

Try applying the sorting in 'Load Order' and this should work

-Haneesh

[raghavsurya]

Hi,

In Sort tab click on Load Original.

Regards,

Raghav

[johnw]

I'd actually sort it in numeric order. I don't want a mistake in the spreadsheet to ruin my sort order. If sorting in numeric order doesn't work, then you're probably not reading it in as a date, which is what I'd do. Something like this:

date(date#(MonthYear,'MMM-YYYY'),'MMM-YYYY') as MonthYear