topic Re: MonthName - How to sort by January --> December in QlikView

MonthName - How to sort by January --> December

Thu, 17 Apr 2014 03:56:32 GMT

Hi folks,

How do I manually sort the month selection tab to show the order of months the right way. Please view the image below for further clarification:

Please advise. Thanks in advance.

Best Regards,

Re: MonthName - How to sort by January --> December

its_anandrjs — Thu, 17 Apr 2014 04:01:48 GMT

use sort sequence for that like

Load * inline

[

Month, SeqOrder

December, 1

February, 2

January, 3

May, 4

];

and in list box month uncheck all and then select expression and type SeqOrder there

Re: MonthName - How to sort by January --> December

Thu, 17 Apr 2014 04:02:18 GMT

Goto the Sort Tab of the chart or list box. Click on the Expression. Write something like this

Match(<your month field>,'December','February','January','May)

Re: MonthName - How to sort by January --> December

its_anandrjs — Thu, 17 Apr 2014 04:08:36 GMT

If you want to sort the months manually then use match function like

=Match(Yourmonthfield,'December','February','January','May')

and type this code in the Expression tab.

Re: MonthName - How to sort by January --> December

Thu, 17 Apr 2014 04:09:52 GMT

Go to the sort tab, remove all existing sorting and add this "month(date#(Mon,'MMM'))" where "Mon" is the name of your field.

Thanks,

Jyotsna

Re: MonthName - How to sort by January --> December

jagan — Thu, 17 Apr 2014 04:22:05 GMT

Hi Ram,

In load script arrive a new month field like below, and in Sort tab of chart properties -> Number -> Select Ascending/descending based on your requirement.

TableName:

LOAD

Date(DateDimensionName, 'MMMM')

FROM DataSource;

Regards,

Jagan.

Re: MonthName - How to sort by January --> December

jagan — Thu, 17 Apr 2014 04:33:27 GMT

Hi Ram,

I think doing this script is better option then using Match() in Sort tab, because wherever you are using Month as dimension there you need to give this. It is difficult to handle if you are using Month in multiple charts/listboxes.

Regards,

Jagan.

Re: MonthName - How to sort by January --> December

Thu, 17 Apr 2014 04:34:46 GMT

Hi,

Use this expression in Sort tab for sorting the month names as you like

=Only({1} Match(Month,'Janaury','Febraury','March','April','May','June','July','August','September','October','November','December'))

Note: Please change the months in the expression as per your requred sort order.

Hope it heps you..