topic Re: num format in QlikView

num format

Anonymous — Thu, 09 Apr 2015 09:41:13 GMT

Hi ,

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

Thanks,

jpenuliar — Thu, 09 Apr 2015 13:27:09 GMT

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

Thu, 09 Apr 2015 13:47:59 GMT

This blog post might be useful for you also