topic Convert single digit to double digit in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492937#M184370 <HTML><HEAD></HEAD><BODY><P>Hi all, I have a very simple doubt.</P><P></P><P>I am using month function as : Num(Month(Now()),'##')</P><P>It is showing me the output as 9, whereas I am looking for output as 09.</P><P></P><P>Any help is appreciated.</P><P></P><P>Regards,<BR />Sagar</P><P></P></BODY></HTML> Fri, 06 Sep 2013 11:35:52 GMT 2013-09-06T11:35:52Z Convert single digit to double digit in Qlikview https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492937#M184370 <HTML><HEAD></HEAD><BODY><P>Hi all, I have a very simple doubt.</P><P></P><P>I am using month function as : Num(Month(Now()),'##')</P><P>It is showing me the output as 9, whereas I am looking for output as 09.</P><P></P><P>Any help is appreciated.</P><P></P><P>Regards,<BR />Sagar</P><P></P></BODY></HTML> Fri, 06 Sep 2013 11:35:52 GMT https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492937#M184370 2013-09-06T11:35:52Z Re: Convert single digit to double digit in Qlikview https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492938#M184371 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>You can use </P><P></P><P>=num(Month(Now()),'00')</P><P></P><P>Thanks</P><P>ASINGH</P></BODY></HTML> Fri, 06 Sep 2013 11:45:26 GMT https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492938#M184371 2013-09-06T11:45:26Z Re: Convert single digit to double digit in Qlikview https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492939#M184372 <HTML><HEAD></HEAD><BODY><P>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..</P><P></P><P>Angad, thank you for your response. It worked perfectly. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 06 Sep 2013 11:51:03 GMT https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492939#M184372 2013-09-06T11:51:03Z Re: Convert single digit to double digit in Qlikview https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492940#M184373 <HTML><HEAD></HEAD><BODY><P>Please mark the question as answered</P><P></P><P>Thanks</P></BODY></HTML> Fri, 06 Sep 2013 11:53:13 GMT https://community.qlik.com/t5/QlikView/Convert-single-digit-to-double-digit-in-Qlikview/m-p/492940#M184373 2013-09-06T11:53:13Z