num format

[Anonymous]

Hi ,

Can you give explanation of # and 0 formates in num function.

Thanks,

[jpenuliar]

To denote a specific number of digits, use the symbol "0" for each digit.

To denote a possible digit, use the symbol "#". If the format contains only #'s to the left of the decimal point, numbers less

To mark the position of the thousands separator or the decimal separator, use the thousands separator and the decimal separator.

Qlikview Reference Manual

-

Format Codes for Interpretation

and Formatting Functions Page 865

[#3]

This blog post might be useful for you also

Automatic Number Interpretation