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,
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.