topic Re: Num() and Format codes in QlikView

Num() and Format codes

girirajsinh — Wed, 25 Nov 2020 16:16:04 GMT

Hello Folks,

Could any one explain in simple why / how Num() function give following result ?

I am not getting clear on the login on how it works.

I always understood that first it should prefer the format code defined within the function and if there is none specified then it follow what is mentioned in environment variable. Isn't it so ?

Also what does # this means ? If there is format code like # ##0.0## does it that there would be always 3 digits after the decimal ?

Thanks

It is always great to hear from you !

Giri

Re: Num() and Format codes

marcus_sommer — Mon, 09 Jan 2017 08:21:06 GMT

The # sign is a wildcard for a single digit - if there is a digit available it will be show it - if there is none nothing will be displayed. This meant by a format-code like: # ##0.0##

num(0.123, '# ##0.0##') displayed 0.123

num(0.1, '# ##0.0##') displayed 0.1

num(0.1, '# ##0.000') displayed 0.100

- Marcus

Re: Num() and Format codes

mvaugusto — Thu, 16 Feb 2017 13:40:37 GMT

this works fine!

Thanks