Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lyndluyt
Contributor III
Contributor III

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

1 Solution

Accepted Solutions
Not applicable

Hi,

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

View solution in original post

6 Replies
Not applicable

Hi,

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

View solution in original post

lyndluyt
Contributor III
Contributor III
Author

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

Thanks for the help.

ToniKautto
Employee
Employee

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

jagan
Luminary Alumni
Luminary Alumni

HI,

Try formatting with Num() like below

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

Hope this helps you.

Regards,

Jagan.

lakshmikandh
Specialist II
Specialist II

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
Contributor
Contributor