Auto Formating of numbers / remove decimals

[GillBech]

Hello

In one of my graphs, depending on the filters, figures can vary between units and millions.

I chose to let Qlik sense decide the format of number to get M or k or nothing as a unit.

But I would like to remove decimals

when it's Millions, Qlik Sense shows 23.24 M I would like 23 M
when it's k, Qlik Sense shows 103.56 k I would like 104 k
Is there a way in Auto formatting to discard decimal part ?

Thanks

[vinieme12 · Accepted solution]

Refer this article

https://qlikviewcookbook.com/2016/05/scaling-numbers-and-dse-tips/

[GillBech]

Thanks