Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guruprem
Contributor III

Num(Month) as 01,02 etc...

Hi,

I have Month field data as Jan, Feb, Mar...

When I did num(Month) it is displaying as 1,2,3,4,... however I need as 01,02,03... Please help.

P.S: I tried num(Month,'##') but didn't help

1 Solution

Accepted Solutions

Re: Num(Month) as 01,02 etc...

Num(Month,'00')

1 Reply

Re: Num(Month) as 01,02 etc...

Num(Month,'00')

Community Browser