Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Number Format Clarification

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


1 Reply
swuehl
MVP
MVP

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