topic Re: SET NumberFormat= in App Development

SET NumberFormat=

k_holt69 — Thu, 13 Feb 2025 11:59:41 GMT

In the Main Section we can set various default formats eg SET TimeFormat='hh:mm:ss';

Is it possible to do the same for number format to a set number of decimal places such as SET NumberFormat='###0.000';

Thanks in advance

Re: SET NumberFormat=

Or — Thu, 13 Feb 2025 12:18:30 GMT

Unless this is a hidden feature, I don't think there's a variable for that. The ones generated at the top of every new app match the list of ones available per the documentation.

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/NumberInterpretationVariables/number-interpretation-variables.htm

Re: SET NumberFormat=

k_holt69 — Thu, 13 Feb 2025 12:40:29 GMT

Thanks Or, was looking for an alternate to using num#(num_field,'###0.000').

I'm getting the data from excel with a number of fields that have more than 2 decimal places and was hoping I could set it as a default rather than having to write the above for every field I need to change.

Re: SET NumberFormat=

Or — Thu, 13 Feb 2025 14:24:45 GMT

You could use Floor() or Round() rather than Num#, which would make more sense if the value is already numeric, but otherwise I don't think there's a quick hack for this during the preliminary load process. You could loop through the fields and do this, but it seems like it would just make life harder, not easier.

Re: SET NumberFormat=

Chanty4u — Sun, 16 Feb 2025 14:13:03 GMT

Try this

SET NumberFormat='###0.000';

In your expression

Num(Sum(Sales), '###0.000')

Re: SET NumberFormat=

k_holt69 — Mon, 17 Feb 2025 09:17:32 GMT

Hi Chanty4u.

Thanks but unfortunately this isn't what I was looking for. I'm looking to avoid using expressions and set a default format for all number fields