Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

Hi all,

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

Billions.PNG

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

Billions 2.PNG

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

Billions 3.PNG

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

Thanks a lot,

Kendrick

5 Replies
Not applicable

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

Hi,

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

Regards,

Xavier.

kevinpintokpa
Contributor II

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

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

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

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

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

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

Employee
Employee

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

Hi,

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

Thanks,

Patric Nordström

Qlik

Community Browser