Please be aware that of the difference between the Num() and Num#() function.
- 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: https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/InterpretationFunctions/num_hash.htm
- 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: https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Num.htm
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.