Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Divide your value by 1000000 and apply this custom format : # ##0,00 M
Hi,
Divide your value by 1000000 and apply this custom format : # ##0,00 M
Thanks - I was hoping for something cleaner, but will do that.
Thanks for the help.
Please mark answers as Correct or Helpful, so that others in the community know if the thread needs more attention or not.
HI,
Try formatting with Num() like below
=Num(Sum(MeasureName)/1000000, '#,##0.00 M')
Hope this helps you.
Regards,
Jagan.
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
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.