Skip to main content

Difference between Num() and Num#() function

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Andreas_Giesbrecht

Difference between Num() and Num#() function

Last Update:

May 10, 2022 3:20:13 PM

Updated By:

Jamie_Gregory

Created date:

Jan 8, 2020 3:14:09 AM

Num#() converts a text string to a numerical value, in the number format set in the load script or the operating system, unless a format string is supplied. Custom decimal and thousand separator symbols are optional parameters. For more information: Num# - script and chart function

Num() formats an expression numerically in the number format set in the system variables in the load script, or in the operating system unless a format string is supplied, and optional decimal and thousands separators. For more information: Num - script and chart function

Please also note that both functions can be applied in the script, but also as a chart, however, it is recommended to use string to numerical value conversions in the backend (script) for big applications, as in the frontend those functions could consume a lot of server resources which would affect the application performance.

 

Environment:

QlikView 
Qlik Cloud 
Qlik Sense Business 
Qlik Sense Enterprise on Windows 

Labels (1)
Version history
Last update:
‎2022-05-10 03:20 PM
Updated by: