Million symbol in Qlik Sense

[Anonymous]

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

[#2 · Accepted solution]

Hi,

Divide your value by 1000000 and apply this custom format : # ##0,00 M

[Anonymous]

Thanks - I was hoping for something cleaner, but will do that.

Thanks for the help.

[ToniKautto]

Please mark answers as Correct or Helpful, so that others in the community know if the thread needs more attention or not.

[jagan]

HI,

Try formatting with Num() like below

=Num(Sum(MeasureName)/1000000, '#,##0.00 M')

Hope this helps you.

Regards,

Jagan.

[lakshmikandh]

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

[AbdullahAzzam]

Please check this.

https://community.qlik.com/t5/New-to-Qlik-Sense/Rename-G-to-B-in-Qlik-Sense/td-p/82992

[Nihilor]

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.