topic Re: Month Sorting in QlikView

Month Sorting

Tue, 03 Feb 2015 10:49:29 GMT

Hi All

I have a list box with "Month(DateField)" value. I would like to sort my months in a cronological order (Jan - Dec).

How can i do this?

jonathandienst — Tue, 03 Feb 2015 10:51:36 GMT

Month() returns a dual value, so you should sort on numerical value to get a chronological order.

HTH

Jonathan

Tue, 03 Feb 2015 10:59:40 GMT

Hi,

In object properties sort tab select the dimension and in expression write below

=num(month(datefield))

Regards

Tue, 03 Feb 2015 11:55:24 GMT

Hi Tumelo,

as you are using an expression in your listbox rather than a field, you'll need to use an expression to sort (as samapthbotla has said).

I would recommend actually creating a month field in your script, based on your existing code, so just

Month(DateField) AS Month

You can then just use the field in the listbox and as Jonathan has says, at that point you'll be able to use the standard number sorting option.

This way you are pushing the overhead back into the script, rather than in the UI.

Hope that helps

Joe

Tue, 03 Feb 2015 12:00:26 GMT

Hi Guys

Thanks for all your replies. The month is ordered accordingly. But when concaternate another clculation to the field the months loses the ordering.

is there any way to keep the ordering after using &''& to add another calculation?