Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Adding a Month number as a field

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,

1 Solution

Accepted Solutions
chauhans85
Esteemed Contributor

Adding a Month number as a field

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

2 Replies
chauhans85
Esteemed Contributor

Adding a Month number as a field

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

MVP
MVP

Adding a Month number as a field

Hi,

Hope this discussion helps you.

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

Regards,

Jagan.

Community Browser