Discussion Board for collaboration related to QlikView App Development.
I have a list box. The dimension in that List Box is Period Name. It has the values as SEP,JAN,MAR,JUN,FEB........
How do I sort it to show JAN,FEB,MAR,APR,MAY....................DEC.
What is the best setting that I should do in my sort tab to fix this.
For months load num value also in load like
Month -> JAN,FEB,MAR,APR,MAY....................DEC
MonthNum -> 1,2,3,4,5,6,7,8,9,10,11,12
and in list box of the sort option use MonthNum field for sort
In list box of the Month in sort -> expression
Best way is add MonthNum field.
Month function will return a three letter month name code, according to your settings in the load script:
From the Help:
Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.
month( '1971-10-30' ) returns Oct.
Basically, it will return one of the text values defined in your script, like in my setting: