topic num and num# format in QlikView

num and num# format

Sat, 08 Nov 2014 08:25:58 GMT

hey everyone,

i have this doubt.maybe a silly one! i know about the num and num# functions and how they work.but i'm confused when i have to specify the format.what i mean is '00' or '0.00' is fine,but what's the use of '#' in there.how do you i use that to specify various formats?

thanking you,

kunal bhattcharjee

Re: num and num# format

maxgro — Sat, 08 Nov 2014 08:50:59 GMT

you can read these about format

http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/18/number-format-codes

or try yourself in the number tab

make a listbox with some values (eg mine is =valuelist(7, 0.7) ), change format and apply to see the result in listbox and format in format pattern

Re: num and num# format

MarcoWedel — Tue, 11 Nov 2014 00:10:14 GMT

Hi,

here's an explanation from the QV help file:

Numbers

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 than 1 begin with a decimal point.
To mark the position of the thousands separator or the decimal separator, use the thousands separator and the decimal separator.

hope this helps

regards

Marco

Re: num and num# format

Tue, 11 Nov 2014 04:38:00 GMT

hi,marco

can you elaborate the second point with an example?

thanking you,

kunal bhattacharjee

Re: num and num# format

ashfaq_haseeb — Tue, 11 Nov 2014 05:30:23 GMT

Hi,

Check this

http://community.qlik.com/message/538561#538561

Regards

ASHFAQ