topic Arranging Months in QlikView

Arranging Months

rathnam_qv — Sun, 25 Aug 2013 13:32:16 GMT

Hi all,

i have months from Jan,Feb....Dec.

but i want to display from Nov,Dec,Jan,Feb....Sep,Oct

is it possible if so,please help me

Thanks in advance!!!

Smiley

Re: Arranging Months

ariel_klien — Sun, 25 Aug 2013 14:03:49 GMT

Hi,

you can write in your script an inline table like this:

LOAD * INLINE [

Month, month_num

Nov, 1

Dec, 2

Jan, 3

Feb, 4

Mar, 5

Apr, 6

May, 7

Jun, 8

Jul, 9

Aug, 10

Sep, 11

Oct, 12

];

and then sort it by month_num

Ariel

Re: Arranging Months

fernando_tonial — Sun, 25 Aug 2013 14:20:37 GMT

Hi,

You can try this:

Map_Month

Mapping

LOAD * INLINE [

Month, month_num

Nov, 1

Dec, 2

Jan, 3

Feb, 4

Mar, 5

Apr, 6

May, 7

Jun, 8

Jul, 9

Aug, 10

Sep, 11

Oct, 12

];

Data:

Load

Dual(Month, ApplyMap('Map_Month',Month) as Month

From Table;

This form will be ordering as you set the mapping table.

Best Regards.

Tonial.

Re: Arranging Months

jagan — Sun, 25 Aug 2013 14:42:15 GMT

Hi Rathnam,

Arrive month field in the script like this

Load

Dual(MonthNameDimension, Match(MonthNameDimension, 'Nov', 'Dec', 'Jan', ............'Oct')) AS Month

FROM DataSource;

Hope this helps you.

Regards,

Jagan.