Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Showing month in list box


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

Tags (1)
2 Replies
Contributor III

Re: Showing month in list box

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')

Valued Contributor II

Re: Showing month in list box

Try sorting the text to A-Z

Community Browser