topic Re: Sort months by name in QlikView

Sort months by name

Wed, 15 Jun 2016 10:44:51 GMT

hello, I have a calculated field that returns the name of the month.
I would like to enter this field in a table and sort by name month (in Italian).
I'm applying the function

dual ([Date planned delivery], if ([Date planned delivery] = 'Gennaio', - 1, num ([Date planned delivery])))

but it does not work.
I also applied to the expression:

= Match ([Date planned delivery], $ (= chr (39) & Replace (MonthNames, ';', chr (39) & ',' & chr (39)) & chr (39)))

but even this works correctly.

Does anyone have any idea what it should use?

Re: Sort months by name

sunny_talwar — Wed, 15 Jun 2016 10:46:30 GMT

Would you be able to share a sample?

Re: Sort months by name

Wed, 15 Jun 2016 10:50:49 GMT

If I use the expression the result is:

and its' wrong.

The correct result is:

Gennaio (January)

Marzo (March)

Aprile (April)

Maggio (May

Giugno (June)

Re: Sort months by name

sunny_talwar — Wed, 15 Jun 2016 10:53:59 GMT

Can you try this as your calculated dimension:

Date(Date#(Upper(MonthFieldName), 'MMMM'), 'MMMM')

Month(Date#(Upper(MonthFieldName), 'MMM'))

Re: Sort months by name

Thu, 16 Jun 2016 13:34:59 GMT

The result is not correct. If I use your formula the result is:

But I would that the order is:

gennaio (Jenuary)

marzo (March)

aprile (April)

maggio (May)

giugno (June)

luglio

agosto

settembre

ottobre

novembre

dicembre

Re: Sort months by name

sunny_talwar — Thu, 16 Jun 2016 13:46:37 GMT

Can you share your environmental variables from the script?

They would look something like this

Re: Sort months by name

Thu, 16 Jun 2016 14:12:56 GMT

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;-€ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';

SET DayNames='lun;mar;mer;gio;ven;sab;dom';

Re: Sort months by name

sunny_talwar — Thu, 16 Jun 2016 14:15:55 GMT

Add one more to the list:

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

But change the month names to your Month Names

gennaio (Jenuary)

marzo (March)

aprile (April)

maggio (May)

giugno (June)

luglio

agosto

settembre

ottobre

novembre

dicembre

Once this is done try this once again -> Date(Date#(MonthFieldName, 'MMMM'), 'MMMM')

Re: Sort months by name

tamilarasu — Thu, 16 Jun 2016 14:21:56 GMT

You can use sort expression like below,

=Date(Date#(Left(FieldName,3),'MMM'),'MMM')