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
QlikWorld May 10-12, Online and Free! REGISTER NOW
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
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
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
Contributor II

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

Patric_Nordstrom
Employee
Employee

Hi,

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

Thanks,

Patric Nordström

Qlik

AbdullahAzzam
Contributor
Contributor