Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month sort in the Listbox

HI guys,

Looks simple but I dont get.

I load from the excel sheet. The columns there are 2010Jan, 2010Feb, 2010Mar etc..like this.

I load it with the following script as crosstable.


right(left(YearMonth,12),3) as Month


After loading and when I want to display as a list box it is displayed as followed and I cannot sort it in any way. Any ideas??

error loading image

1 Solution

Accepted Solutions
martin59
Specialist II
Specialist II

If I were you, I created an Inline Table which contains two Fields : MonthName and MonthNo.

Do a join or a mapping with your main table and sort your field with expression : Only(MonthNo)

Hope it helps you.

View solution in original post

4 Replies
martin59
Specialist II
Specialist II

If I were you, I created an Inline Table which contains two Fields : MonthName and MonthNo.

Do a join or a mapping with your main table and sort your field with expression : Only(MonthNo)

Hope it helps you.

Not applicable
Author

Hello Martin,

I know that way but still I wonder it cannot be solved in an another way. Thanks for ur feedback.

suniljain
Master
Master

Dear Saravan,

I am alredy using same scenario. you have to give Month Numbering in Inline Table . then only you can sort month data in list box.

Regards

Sunil Jain.

Not applicable
Author

Bonjour a tous,

I applied the same.

BUT, have a look at http://community.qlik.com/forums/t/42497.aspx

When we have a click on the month, everything goes unsorted again.

if we use the month in a chart, you will have unsorted month in the chart which is not right?

If you have some fix., please let me know?

Merci et bon weekend!