topic What is the difference B/W Num and Num in QlikView https://community.qlik.com/t5/QlikView/What-is-the-difference-B-W-Num-and-Num/m-p/501824#M187481 <HTML><HEAD></HEAD><BODY><P>Give me good examples where can i use</P></BODY></HTML> Tue, 10 Sep 2013 09:55:54 GMT sreeni_qvd 2013-09-10T09:55:54Z What is the difference B/W Num and Num https://community.qlik.com/t5/QlikView/What-is-the-difference-B-W-Num-and-Num/m-p/501824#M187481 <HTML><HEAD></HEAD><BODY><P>Give me good examples where can i use</P></BODY></HTML> Tue, 10 Sep 2013 09:55:54 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-B-W-Num-and-Num/m-p/501824#M187481 sreeni_qvd 2013-09-10T09:55:54Z Re: What is the difference B/W Num and Num https://community.qlik.com/t5/QlikView/What-is-the-difference-B-W-Num-and-Num/m-p/501825#M187482 <HTML><HEAD></HEAD><BODY><P>AFAICS there is none.</P><P></P><P>Do you mean the difference between Num and Num#?</P><P></P><UL><LI>Num() formats a parameter value according to a format specification (OUTPUT)<BR />e.g. LET vOutput = Num(12345, '$ #.00') will store something like '$ 12345.00' into vOutput</LI><LI>Num#() forces interpretation of a parameter value according to a fixed pattern (INPUT)<BR />e.g. a column in a LOAD statement like &lt;Num#(InputValue, '0.00', ',', '.') as NewColumn&gt; will lift the digits, force interpretation with the sepcificed separators as a number and store the resulting value in NewColumn.</LI></UL><P></P><P>QlikView Desktop Help contains more examples. Search for Num#</P><P></P><P>I may have misinterpreted your question.</P><P></P><P>Peter</P></BODY></HTML> Tue, 10 Sep 2013 10:13:36 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-B-W-Num-and-Num/m-p/501825#M187482 Peter_Cammaert 2013-09-10T10:13:36Z