
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fortunately, the trillion symbol is indeed a T, due to the tera- prefix. (1 terabyte is 1TB)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Custom number abbreviations is most likely coming in April 2018 release of Qlik Sense.
Thanks,
Patric Nordström
Qlik

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
