Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

num format

Hi ,

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

Thanks,

2 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

This blog post might be useful for you also

Automatic Number Interpretation