Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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.
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.
Hello Martin,
I know that way but still I wonder it cannot be solved in an another way. Thanks for ur feedback.
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.
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!