Discussion Board for collaboration related to QlikView App Development.
hi to all,
Anyone of you explain how to sort the month by order.
My month dimension like below
But I want month list like
That's because your month is a text field. Convert it to a proper month field during load. The month field is a dual with the month number as a value and a text representation of the 3 character month name.
Month As MonthText, // do you need this field?
Month(Date#(Month & '2015', 'MMMYYYY')) As Month,
(the year used is irrelevant)
This month field should be sorted numerically (as is usual for dual values)
Hi try this
LOAD * INLINE [
Then in list box of Month Go to Sort Tab>Expression write the Month_NO
Thanks And Regards
approach (best done in the script) you might have to adjust your MonthNames variable to
if that's not your local default.
Copy the script and use Sortvalue descending in sort expression.
Load *, INLINE [