What is the difference B/W Num and Num

[sreeni_qvd]

Give me good examples where can i use

[Peter_Cammaert]

AFAICS there is none.

Do you mean the difference between Num and Num#?

• Num() formats a parameter value according to a format specification (OUTPUT)
  e.g. LET vOutput = Num(12345, '$ #.00') will store something like '$ 12345.00' into vOutput
• Num#() forces interpretation of a parameter value according to a fixed pattern (INPUT)
  e.g. a column in a LOAD statement like <Num#(InputValue, '0.00', ',', '.') as NewColumn> will lift the digits, force interpretation with the sepcificed separators as a number and store the resulting value in NewColumn.

QlikView Desktop Help contains more examples. Search for Num#

I may have misinterpreted your question.

Peter