num and num# format

[#1]

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

[maxgro]

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

[MarcoWedel]

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

[#4]

hi,marco

can you elaborate the second point with an example?

thanking you,

kunal bhattacharjee

[ashfaq_haseeb]

Hi,

Check this

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

Regards

ASHFAQ