Round Millions to #.#M

Tue, 01 May 2012 15:07:58 GMT

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!

Round Millions to #.#M

SunilChauhan — Tue, 01 May 2012 15:16:06 GMT

$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

topic Round Millions to #.#M in QlikView

Round Millions to #.#M

Round Millions to #.#M