Month sort in the Listbox

[#1]

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

[martin59 · Accepted solution]

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.

[#3]

Hello Martin,

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

[suniljain]

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.

[#5]

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!