
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Million symbol in Qlik Sense
Hi All
I am trying to format the data to show in millions on most occasions. The AUTO format doesn't always display it that way and I want to force the display.
Is there a way?
Thanks
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Divide your value by 1000000 and apply this custom format : # ##0,00 M

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Divide your value by 1000000 and apply this custom format : # ##0,00 M

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks - I was hoping for something cleaner, but will do that.
Thanks for the help.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please mark answers as Correct or Helpful, so that others in the community know if the thread needs more attention or not.

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
Try formatting with Num() like below
=Num(Sum(MeasureName)/1000000, '#,##0.00 M')
Hope this helps you.
Regards,
Jagan.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can change the auto number formatting symbol from "G" to "B" in javascript
Please check this Steps to Change : Qlik Sense - Billions number format 'G' to 'B'
Thanks,
Lakshmikandh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bonjour,
L'inconvénient de ce formatage est qu'il est mal traduit lors de l'exportation des données en format xls.
Avez-vous une solution différente ? Un modèle de format dynamique comme le formatage "auto", mais paramétrable ?
Bonne journée.
