topic Recovery values with the original formatting in QlikView https://community.qlik.com/t5/QlikView/Recovery-values-with-the-original-formatting/m-p/780722#M276626 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Good morning</SPAN>, <SPAN class="hps">I have</SPAN> <SPAN class="hps">the following problem</SPAN>:</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">I access</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">AS400</SPAN> <SPAN class="hps">to read a</SPAN> <SPAN class="hps">numeric field</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">numeric type</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">length</SPAN> <SPAN class="hps">9</SPAN>.</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">When the</SPAN> <SPAN class="hps">recovery and</SPAN> <SPAN class="hps">read</SPAN> <SPAN class="hps">the value</SPAN> <SPAN class="hps">from</SPAN> <SPAN class="hps">QlikView</SPAN> <SPAN class="hps">is not long</SPAN> <SPAN class="hps">nine</SPAN> <SPAN class="hps">but</SPAN> <SPAN class="hps">value is displayed</SPAN> <SPAN class="hps">(eg</SPAN> <SPAN class="hps">1</SPAN>, <SPAN class="hps">2</SPAN>, <SPAN class="hps">50</SPAN>, <SPAN class="hps">120</SPAN>, <SPAN class="hps">etc.</SPAN>).</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">How can I</SPAN> <SPAN class="hps">automatically add</SPAN> <SPAN class="hps">zeros</SPAN> <SPAN class="hps">before the number</SPAN> <SPAN class="hps">recovered</SPAN> <SPAN class="hps">in order to have</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">length</SPAN> <SPAN class="hps">field </SPAN><SPAN class="hps">nine</SPAN>?<BR /><BR /> <SPAN class="hps">Thanks</SPAN></SPAN></P></BODY></HTML> Wed, 28 Jan 2015 11:04:59 GMT 2015-01-28T11:04:59Z Recovery values with the original formatting https://community.qlik.com/t5/QlikView/Recovery-values-with-the-original-formatting/m-p/780722#M276626 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Good morning</SPAN>, <SPAN class="hps">I have</SPAN> <SPAN class="hps">the following problem</SPAN>:</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">I access</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">AS400</SPAN> <SPAN class="hps">to read a</SPAN> <SPAN class="hps">numeric field</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">numeric type</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">length</SPAN> <SPAN class="hps">9</SPAN>.</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">When the</SPAN> <SPAN class="hps">recovery and</SPAN> <SPAN class="hps">read</SPAN> <SPAN class="hps">the value</SPAN> <SPAN class="hps">from</SPAN> <SPAN class="hps">QlikView</SPAN> <SPAN class="hps">is not long</SPAN> <SPAN class="hps">nine</SPAN> <SPAN class="hps">but</SPAN> <SPAN class="hps">value is displayed</SPAN> <SPAN class="hps">(eg</SPAN> <SPAN class="hps">1</SPAN>, <SPAN class="hps">2</SPAN>, <SPAN class="hps">50</SPAN>, <SPAN class="hps">120</SPAN>, <SPAN class="hps">etc.</SPAN>).</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">How can I</SPAN> <SPAN class="hps">automatically add</SPAN> <SPAN class="hps">zeros</SPAN> <SPAN class="hps">before the number</SPAN> <SPAN class="hps">recovered</SPAN> <SPAN class="hps">in order to have</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">length</SPAN> <SPAN class="hps">field </SPAN><SPAN class="hps">nine</SPAN>?<BR /><BR /> <SPAN class="hps">Thanks</SPAN></SPAN></P></BODY></HTML> Wed, 28 Jan 2015 11:04:59 GMT https://community.qlik.com/t5/QlikView/Recovery-values-with-the-original-formatting/m-p/780722#M276626 2015-01-28T11:04:59Z Re: Recovery values with the original formatting https://community.qlik.com/t5/QlikView/Recovery-values-with-the-original-formatting/m-p/780723#M276627 <HTML><HEAD></HEAD><BODY><P>Num(field,'000000000')</P></BODY></HTML> Wed, 28 Jan 2015 11:20:26 GMT https://community.qlik.com/t5/QlikView/Recovery-values-with-the-original-formatting/m-p/780723#M276627 MarcoWedel 2015-01-28T11:20:26Z