topic How to sort month in QlikView

How to sort month

Sat, 12 Mar 2011 09:09:33 GMT

Hi,

Have a look at the attached and see if you have a solution?

Thanks.

How to sort month

maneshkhottcpl — Sat, 12 Mar 2011 09:58:30 GMT

Hi,

Please refer the attached application.

Right CLick - MonthField--Sort--Remove all sort check boxes

How to sort month

Sat, 12 Mar 2011 11:26:48 GMT

Thanks Manesh for the suggestion.

But it is not working for me. We need to have a sort.

Other alternatives?

How to sort month

suniljain — Sat, 12 Mar 2011 13:09:44 GMT

You need sort based on Fiscal or Calendar Year ?. Because Your Inline have Month Sequence based on Fiscal Year

How to sort month

francisvandergr — Sat, 12 Mar 2011 13:23:09 GMT

Ha,

Inline table like

01 jan

02 feb

03 maart

How to sort month

Sun, 13 Mar 2011 08:06:47 GMT

yup... this is the solution, at the start of the script, load the month and their number in sequence... then, later part in the listbox, just sort this field by LOAD sequence.

It seems like the sort by expression will only work if it's static, once it's click, the sequence goes wrong.

How to sort month

Stefan_Walther — Sun, 13 Mar 2011 10:02:58 GMT

Just use a normal Date field (using a dual type) and sort it by the numeric value, then this would work ...

Hope this helps!

Regards
Stefan

How to sort month

maneshkhottcpl — Mon, 14 Mar 2011 07:15:59 GMT

Hi,

Can u explain ur need in more details?

Regards

Manesh

How to sort month

Anonymous — Tue, 15 Nov 2011 23:11:15 GMT

Hello ... I am facing the same problem. Did you find the right solution?

Thanks in advance

How to sort month

Anonymous — Tue, 15 Nov 2011 23:25:29 GMT

Hello, In your example the sort option that worked fine is to sort by "loaded order" (the last option).

Other options I have tried are do not work properly, it does not respect the order... strange.

Hope it helps,

Javier

Re: How to sort month

johnw — Wed, 16 Nov 2011 00:30:11 GMT

Use actual month values instead of text or whatever else you might be using today. So, for instance, if your raw data contains a month number, you could use this:

month(makedate(2011,MonthNumber)) as Month

It doesn't matter what year you plug in. You're just creating a date temporarily to let QlikView build a month field off of it. Of course I don't know what your raw data looks like, so that's likely not the exact expression you need.