topic Month arranging in QlikView

Month arranging

tenyeapen — Wed, 25 Nov 2020 16:16:04 GMT

HI All

can anybody please help me with arranging all the months in a list box. The month value is picking from an excel sheet. I need the list box to steady in the Jan - Dec order. Sample also attached.

Re: Month arranging

Manyao — Wed, 06 Mar 2019 13:11:01 GMT

Add the following to your Load Statement

MONTH_VIEW:
LOAD * INLINE [
[Approved Month], MONTH_INDEX
January, 01
February, 02
March, 03
April, 04
May, 05
June, 06
July, 07
August, 08
September, 09
October, 10
November, 11
December, 12
];

Then sort by Month_index in your list

Re: Month arranging

MindaugasBacius — Wed, 06 Mar 2019 13:11:06 GMT

Use an Inline before the whole script. Then drop the table.
sort_month:
LOAD * INLINE [
Approved Months
January
...
December
];

Drop Table sort_month;

Re: Month arranging

hopkinsc — Wed, 06 Mar 2019 13:15:11 GMT

use an inline load in the beginning of the load script (after variables). give it the same field name, then drop at the end of the script. once reloaded, change the sort order to 'Load Order'

MonthSort:

load * inline [

Approved Month

January

February

March

April

etc

]

;