Number Formating

[bnelson111]

I have a field that sums to a number correctly, but I would like the format to be 1,002,333, which should read as 1.002,333, with a period for million separators and a comma for thousands.

[Frank_S]

Have you tried working within the app's load script to update the number format that you want to see.

For example...see the 'SET' statements (lines 1 to 5) in the help page below:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/use-data-load-e...

If you are trying to use multiple number formats within the same app other's here may have ideas for you.

Kind regards.

[henrikalmen]

You can use the num() function to format numbers.