Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
tenyeapen
New Contributor

Month arranging

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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Month arranging

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

]

;

 

3 Replies
Manyao
New Contributor

Re: Month arranging

Hi

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

MindaugasBacius
Valued Contributor III

Re: Month arranging

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

Drop Table sort_month;
Partner
Partner

Re: Month arranging

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

]

;