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: 
GillBech
Contributor III
Contributor III

Auto Formating of numbers / remove decimals

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

 

 

Labels (1)
  • Chart

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Refer this article

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Refer this article

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
GillBech
Contributor III
Contributor III
Author

Thanks