Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting a List Box

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

1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II

Hi there,

go to expression and write the below expression...make sure remaining check boxes are unchecked

only({1}num(Month(Date#(capitalize(left(FieldName,3)),'MMM'))))

Hope this helps

View solution in original post

14 Replies
swuehl
MVP
MVP

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
Specialist II
Specialist II

Hi,

Choose auto ascending option from List box properties..

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

Thanks

Pradeep

Not applicable
Author

This does not work sorry. Already tried this.

Thanks

Not applicable
Author

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')

Not applicable
Author

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
MVP
MVP

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.

ListBox.png