topic Re: Formating Number in Measures in App Development

Formating Number in Measures

ena1309 — Sun, 19 Jun 2022 19:43:51 GMT

Hi Qlikers,

Is there a way to remove these decimals zeros, but to leave MM as milions
FLOOR function is NOT a solution, because then it will convert 5.00MM to 5000000
and I want it to be 5MM

p.s. this is the line from main section in data load editor SET NumericalAbbreviation='3:K;6:MM;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

Thxx

Re: Formating Number in Measures

stevedark — Sun, 19 Jun 2022 22:19:54 GMT

Hi @ena1309

If you set the number format on the chart to Auto it can sometimes do better than if you set a specific number format.

Whether you use floor or not shouldn't impact the scale on the chart, but it's usually best not to use floor, as you lose definition if someone exports the data.

If the Auto format isn't working by itself you can use the num function to format the values, and this will affect the axis labels also. You will need to find the highest value in any month to do this though, by using an aggr function, which is a bit fiddly. Letting the chart sort it out itself is generally the best approach.

Hope that helps.

Steve

Re: Formating Number in Measures

ena1309 — Sun, 19 Jun 2022 22:34:04 GMT

yess this is with AUTO format
that's why is makes it as MM
i just wanted to see is it possible to be 5MM not 5.00MM
🙂

Re: Formating Number in Measures

stevedark — Sun, 19 Jun 2022 22:45:44 GMT

Hi @ena1309

Unfortunately, that is the issue with the Auto format, you don't get to chose. Without the Auto format, you will get 5,000,000 or similar.

You could try a rounded version of the field in the load and then use that in the expression and see what happens, so in the load:

LOAD
FreeStockAmt,
round(FreeStockAmt, 1) as FreeStockAmtRounded,

And then use the rounded version in the chart and see if that works.

Steve

Re: Formating Number in Measures

luiferva — Mon, 20 Jun 2022 01:20:42 GMT

Hola Ena1309, podrias entrar a expresiones y dividir el numero de tu metrica algo asi

para que se quiten los 0

-Luego editas el patron de formato de tu medida de esta forma

Resultado

Espero te sea de ayuda.