Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert single digit to double digit in Qlikview

Hi all, I have a very simple doubt.

I am using month function as : Num(Month(Now()),'##')

It is showing me the output as 9, whereas I am looking for output as 09.

Any help is appreciated.

Regards,
Sagar

1 Solution

Accepted Solutions
Not applicable
Author

Hello,

You can use

=num(Month(Now()),'00')

Thanks

ASINGH

View solution in original post

3 Replies
Not applicable
Author

Hello,

You can use

=num(Month(Now()),'00')

Thanks

ASINGH

Not applicable
Author

Thanks Mohit. Actually my function is Num(Month(Now()-1),'##') because I want to get the last month. I cant use the Today() function in that case..

Angad, thank you for your response. It worked perfectly.

Not applicable
Author

Please mark the question as answered

Thanks