topic Month name to numbers in QlikView

Month name to numbers

Fri, 26 Aug 2011 07:30:04 GMT

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.

Anonymous — Fri, 26 Aug 2011 07:44:17 GMT

Use this:

Num(Month(Date_Field))

SunilChauhan — Fri, 26 Aug 2011 07:44:25 GMT

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

;

];

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

thanks

Sunil Chauhan

Fri, 26 Aug 2011 07:50:06 GMT

thanks bala , i got it with your solution