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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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