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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
akuttler
Creator
Creator

Chart Custom Number Formatting

How to change "9,324,794.00 " to "9.32M "??

2 Replies
petter
Partner - Champion III
Partner - Champion III

Num( Amount / 1000000 , '0.00M','.',',')

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

Chart properties > Data > select your measure > Change number formatting from "auto" to number for example and use the drop down menu to select your desired format. You can also use the custom format, but then you'll need to type the format function like "num(Field, '#,##0')

regards