How can I format my Measure/Y-Axis to 1M instead of $100,000.000? And 10k instead of $10,000?

[jblomqvist]

Hi all,

How can I manually format format my Measure/Y-Axis to 1M instead of $100,000.000? And 10k instead of $10,000?

For example in the example below it shows my sales as $1,000,000.00 I want that to be $1m instead. And automatically change to $10K when it is around $10,000

Anyone know how to do this?

[rwunderlich · Accepted solution]

See this post. It applies to Qlik  Sense as well.

Scaling Numbers and DSE Tips | Qlikview Cookbook

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Hi

FYI

But this will work if chart height is enough to show static step (go to axis tab)

check the below links :

Currency and Other Symbols on the Y-Axis | Qlikview Cookbook

$ in y -axis label

[jblomqvist]

Rob that is fantastic please keep sharing your knowledge