Discussion board where members can get started with QlikView.
In script try like this
Dual(xbasedelivmonth, Match(xbasedelivmonth, 'JANUARY', 'FEBRUARY', 'MARCH', 'APRIL', 'MAY', 'JUNE', 'JULY', 'AUGUST', 'SEPTEMBER', 'OCTOBER', 'NOVEMBER', 'DECEMBER')) AS Month
Now in Chart/List box Select Numeric in Sort tab.
Hope this helps you.
thanks it worked,but the ranks are shown ,how do I get the month names.
eg: if you see sheet 5 in my file attached file how do I pull the rearranged names?? like in my list box delivery details I want the months to be present in the Jan to Dec order... how to do it??Please help.
Write this in that list box properties-->sort tab-->expression
Ouch!!! It hurts to see that so many people suggest an inline table to solve this problem...
An inline table will work, but it is a clumsy method. It is much better to interpret the month name so that it gets a dual format that automatically gets sorted correctly . Here's how you should do it:
First, make sure that you have the environment variables in the beginning of the script:
SET LongMonthNames= 'JANUARY;FEBRUARY;MARCH;APRIL;MAY;JUNE;JULY;AUGUST;SEPTEMBER;OCTOBER;NOVEMBER;DECEMBER';
Then, you can just use the following to interpret the month names. MMM means short month names, MMMM means long month names.
Month(Date#(Month,'MMMM')) as Month
No inline table is needed.