topic Re. :Month sort in the Listbox in QlikView

Month sort in the Listbox

Thu, 29 Jul 2010 13:49:03 GMT

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 — Thu, 29 Jul 2010 13:52:52 GMT

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.

Thu, 29 Jul 2010 13:57:21 GMT

Hello Martin,

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

suniljain — Thu, 29 Jul 2010 14:11:13 GMT

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.

Sat, 12 Mar 2011 09:19:35 GMT

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!