Adding a Month number as a field

[#1]

Hi All,

I would appreciate if you could help.

I would like to add a month number as filed, I have a Field called ABC_Mth and is displayed as 'MMM' but it's loaded by a set financial year  and would like it to set it the same way as the calendar year, i.e. Jan, Feb, Mar,...

Regards,

[SunilChauhan · Accepted solution]

load below code also

Load * inline [

ABC_Mth ,Monthno

Jan,1

Feb,2

Mar,3

Apr,4

May,5

Jun,6

Jul,7

Aug,8

Sep,9

Oct,10

Nov,11

Dec,12

];

hope this helps

[jagan]

Hi,

Hope this discussion helps you.

http://community.qlik.com/message/203609#203609

Regards,

Jagan.