topic Re: Sort order in QlikView

Sort order

mato32188 — Tue, 03 Jun 2014 06:36:52 GMT

Hello,

I have a problem with sorting year-month dimension in chart. Format is 20XX-Jan, 20XX-Feb

Could anybody help to sort it chronologically?

Thanks

ashfaq_haseeb — Tue, 03 Jun 2014 06:42:52 GMT

Hi use

date(Datefield,'YYYY-MMM') as your sorting expression

Regards

ASHFAQ

mato32188 — Tue, 03 Jun 2014 06:51:27 GMT

It works only when expression is..... date#(Datefield, 'YYYY-MMM'), but thank you very much.

vardhancse — Tue, 03 Jun 2014 06:56:56 GMT

Hi,

In the calendar can u create the inline statements separately for year and month with sort numbers.

LOAD * INLINE [

Year, Sort_No

2006, 1

2007, 2

2008, 3

2009, 4

2010, 5

];

Similarly for month,

LOAD * INLINE [

Month, Sort_No

Jan, 1

Feb, 2

Mar, 3

];

So that in front end u can join both .