Number Format Clarification

Anonymous — Thu, 04 Aug 2016 00:21:21 GMT

Hi, Need help on this:

Number format setting 1: # ##0
Number format setting 2: #,##0

Expression: Num( 35648.375, '0.0' )

Output:

Setting 1:

String - 35 648 375

Number - 35648375

Setting 2:

String - 35648.375

Number - 35648.375

How does this work? What is the role of '0.0' here? Does the expression ever consider the format '0.0'? How does a decimal separator in setting 2 makes the difference?

Actually, I take this example from the help. I am not able to understand this from the help. Please help

Re: Number Format Clarification

swuehl — Thu, 04 Aug 2016 21:36:15 GMT

I don't understand the examples neither.

I believe it's useless to only define a format code without defining the decimal and thousand separators, too, either as default using the script variables or explicitely in the num() / num#() function as additional, optional arguments.

And you are right, it doesn't make sense to define two 'number format settings' and then use a different explicite number format in the examples, but discuss the expected result in the context of the 'setting 1' resp. 'setting 2'.

If you want to learn more about number formatting, learn from the masters, like

On Format Codes for Numbers and Dates

The Third Format | Qlikview Cookbook‌

or search this forum, there are some posts that explain the different options better than the HELP.

Best,

Stefan

topic Number Format Clarification in QlikView

Number Format Clarification

Re: Number Format Clarification