Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Can you give explanation of # and 0 formates in num function.
Thanks,
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
This blog post might be useful for you also