Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ena1309
Contributor III
Contributor III

Formating Number in Measures

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

ena1309_0-1655667737120.png

 

Labels (2)
4 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

ena1309
Contributor III
Contributor III
Author

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 
🙂

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

luiferva
Contributor III
Contributor III

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

luiferva_0-1655687846250.png

para que se quiten los 0

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

luiferva_1-1655687983419.png

Resultado

luiferva_2-1655688027869.png

Espero te sea de ayuda.