Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
l26b
Contributor III
Contributor III

Aproximate metric volumes

hi, 

 

I have a kpi with a metric that is showing in millions like 35.76 M. how can I change this to only show 36 M( from 35.76 approximate to 36 M) 

 

My measure it is configured to showa number 1,000 but for millions shows 35.76 milions. 

 

l26b_0-1741610833572.png

 

thank you 

Labels (4)
1 Reply
Chanty4u
MVP
MVP

Try this 

Round(Sum(YourMetric) / 1000000, 1) & ' M'