Sorting a List Box

[#1]

Hello

I have a list box. The dimension in that List Box is Period Name. It has the values as SEP,JAN,MAR,JUN,FEB........

How do I sort it to show JAN,FEB,MAR,APR,MAY....................DEC.

What is the best setting that I should do in my sort tab to fix this.

Thanks

[swuehl]

Create a dual value for example using Month(Date) in your load script, which automatically returns a dual value. Then sort numeric.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/13/dual

[PradeepReddy]

Hi,

Choose auto ascending option from List box properties..

List Box Properties --> Sort -->  Sort By (Choose Auto Ascending)

Thanks

Pradeep

[#4]

This does not work sorry. Already tried this.

Thanks

[#5]

Hello

I do not want Minth(Date). I just want the first three letters of the month.

For example JAN, FEB,....

tHANKS

[its_anandrjs]

For months load num value also in load like

Month -> JAN,FEB,MAR,APR,MAY....................DEC

MonthNum -> 1,2,3,4,5,6,7,8,9,10,11,12

and in list box of the sort option use MonthNum field for sort

Or

In list box of the Month in sort -> expression

write like

=Match(Month,'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

Best way is add MonthNum field.

[its_anandrjs]

Write like the below code in Expression and uncheck other option

=Match(Month,'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

[#8]

Hello Anand

Where should I add this line

=Match(Month,'

JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

In my list box?

Thanks

[swuehl]

Month function will return a three letter month name code, according to your settings in the load script:

From the Help:

month(date)

Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.

Example:

month( '1971-10-30' ) returns Oct.

Basically, it will return one of the text values defined in your script, like in my setting:

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

[its_anandrjs]

In the expression option with your month field this line

=Match(Month,'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

See the attached snap shot.