Skip to main content
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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

6 Replies
Not applicable
Author

Hi,

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

Regards,

Xavier.

kevinpintokpa
Creator II

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
Specialist II

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

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

Patric_Nordstrom
Employee

Hi,

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

Thanks,

Patric Nordström

Qlik