Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Month name to numbers

Hi,

How to get month name into numeric representaion.

like jan as 1, feb as 2 and ....

i already hav a list box which has like jan,feb. i need in form of numerics (1,2,3,..)

thanks.

1 Solution

Accepted Solutions
leni_balakrishn
Contributor III

Month name to numbers

Use this:

Num(Month(Date_Field))

3 Replies
leni_balakrishn
Contributor III

Month name to numbers

Use this:

Num(Month(Date_Field))

chauhans85
Esteemed Contributor

Month name to numbers

if month is Jan,Feb,Mar .....

andfiled is Month

then write

Num(Month)  in list

or use in script as

Num(Month) as Monthnum

or else use

inline wizard like below

load * inline

Month,MonthNum

Jan,1

Feb,2

Mar,3

apr,4

;

;

;

];

or

using if(Month='Jan',1,if(Month='Feb',2,if(Month='Mar,3.........))))))))))))

thanks

Sunil Chauhan

Not applicable

Month name to numbers

thanks bala , i got it with your solution

Community Browser