topic Month Year in QlikView

Month Year

Wed, 04 Aug 2010 07:46:56 GMT

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.

Month Year

Wed, 04 Aug 2010 08:20:47 GMT

Hi,

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

-Haneesh

Month Year

raghavsurya — Wed, 04 Aug 2010 08:36:22 GMT

Hi,

In Sort tab click on Load Original.

Regards,

Raghav

Month Year

johnw — Thu, 05 Aug 2010 01:37:55 GMT

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