Qlik Sense - Billions number format 'G' to 'B'

[#1]

Hi all,

The default number-abbreviation format for billions is set to the international SI unit of "G". This is what I mean:

I'd like to change this to "B". How can I make this happen, either in the app level:

Or the regional level (in this case, what is the script variable to change this?):

Another user had asked this same question last month, here: https://www.qlikcommunity.org/thread/166582‌

Thanks a lot,

Kendrick

[#2]

Hi,

have a look here : Re: Million symbol in Qlik Sense

Regards,

Xavier.

[kevinpintokpa]

I would also like some way to change the 'G' to a 'B'.  No one outside a very small handful of people will know what a 'G' means.  While Xavier_CH199‌'s workaround is appreciated, the QlikView auto-handling of small and large numbers is elegant and I would prefer to use it, but without the 'G'.

While also fixing this, please make sure that Trillion can be set to a T instead of whatever the SI abbreviation is.

[lakshmikandh]

Hi,

You can change the auto number formatting symbol from "G" to "B" in javascript

Please check this https://community.qlik.com/docs/DOC-17461

Thanks,

Lakshmikandh

[ben_mckenna]

Fortunately, the trillion symbol is indeed a T, due to the tera- prefix. (1 terabyte is 1TB)

[Patric_Nordstrom]

Hi,

Custom number abbreviations is most likely coming in April 2018 release of Qlik Sense.

Thanks,

Patric Nordström

Qlik

[AbdullahAzzam]

Please check this.

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