topic Re: Number Formatting in QlikView https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614345#M1112145 <HTML><HEAD></HEAD><BODY><P>num(YourNumberField, '00')</P></BODY></HTML> Fri, 07 Mar 2014 16:43:34 GMT Nicole-Smith 2014-03-07T16:43:34Z Number Formatting https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614344#M1112144 <HTML><HEAD></HEAD><BODY><P>This is probably easy/already been asked but what is an easy way to make a number appear as "01"? It is "01" in my source but Qlikview automatically changed it to "1"</P><P></P><P>Thanks in advance.</P></BODY></HTML> Fri, 07 Mar 2014 16:42:06 GMT https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614344#M1112144 2014-03-07T16:42:06Z Re: Number Formatting https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614345#M1112145 <HTML><HEAD></HEAD><BODY><P>num(YourNumberField, '00')</P></BODY></HTML> Fri, 07 Mar 2014 16:43:34 GMT https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614345#M1112145 Nicole-Smith 2014-03-07T16:43:34Z Re: Number Formatting https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614346#M1112146 <HTML><HEAD></HEAD><BODY><P>If your field containing the number is myField:</P><P></P><P>Num(myField,'00') will format the number as '01' instead of 1</P><P></P><P>hope it helps</P></BODY></HTML> Fri, 07 Mar 2014 16:43:45 GMT https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614346#M1112146 alexandros17 2014-03-07T16:43:45Z Re: Number Formatting https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614347#M1112147 <HTML><HEAD></HEAD><BODY><P>Two solutions:</P><P></P><P>In a chart, use the number tab and specify a custom format</P><P>For all other objects, you can use something like:</P><P></P><P>=num(YourNumber, '00')</P><P></P><P>Formatting always happens as the very last step</P></BODY></HTML> Fri, 07 Mar 2014 16:44:21 GMT https://community.qlik.com/t5/QlikView/Number-Formatting/m-p/614347#M1112147 Peter_Cammaert 2014-03-07T16:44:21Z