topic Adding a Month number as a field in QlikView

Adding a Month number as a field

Fri, 23 Mar 2012 13:29:45 GMT

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,

Adding a Month number as a field

SunilChauhan — Fri, 23 Mar 2012 13:57:16 GMT

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

Adding a Month number as a field

jagan — Fri, 23 Mar 2012 14:07:15 GMT

Hi,

Hope this discussion helps you.

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

Regards,

Jagan.