Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Need help on this:
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
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