Discussion Board for collaboration on QlikView Scripting.
I am extracting the month name from a column using the substr(to_char(MY_DATE), 4, 3) as MONTH. I am able to do it successfully. Now I am getting a problem where my listbox doesnt show the month in the order of Jan-Dec.
I have attached the listbox image.
Any suggestions ??
Goto Sort Tab Add in the Expression
Wildmatch(substr(to_char(MY_DATE), 4, 3),'Jan','Feb','Mar','Apr','May','Jun','Jul','Sep','Oct','Nov','Dec')
Try sorting the text to A-Z