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
