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: 
Not applicable

Round Millions to #.#M

Sometimes you'll want to display millions in a shorter format.  For instance, I may want $23,685,325 to display as $23.6M in my chart.  In order to do that, in your Expressions tab, you'll need to divide your number by 1M and then go to the Number tab, choose your expression, choose Money as Number Format Settings, and in the Format Pattern box, enter this custom format:   $#.#M



Thanks!



1 Reply
SunilChauhan
Champion
Champion

$23,685,325 /1000000

expression divided /1000000                                  // as 1 M$=1000000$

go to number in chart properties  select fieldname ->fixed to 2-> in text write $ before

apply

hope this helps

Sunil Chauhan