Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

Why QS use G instead of B ?

Hi All

Does any one know why does QS automatic display G for billion ? Why can't it allow user change from G to B , because for 1000,000 it display million is correct.

Paul

1 Solution

Accepted Solutions

Re: Why QS use G instead of B ?

Because billion has different meanings:

US - 1 and nine zeros

UK - 1 and 12 zeros

G is international abbreviation

6 Replies

Re: Why QS use G instead of B ?

Because billion has different meanings:

US - 1 and nine zeros

UK - 1 and 12 zeros

G is international abbreviation

soniahelm
New Contributor

Re: Why QS use G instead of B ?

Can the G be converted to a B?

vlad_komarov
Valued Contributor III

Re: Why QS use G instead of B ?

You can always use a Custom formatting and localize it....

VK

soniahelm
New Contributor

Re: Why QS use G instead of B ?

Thanks, for the response, I just decided to show in millions, so divided to avoid confusion.

sri_c003
Contributor

Re: Why QS use G instead of B ?

This formatting holds good when we display fixed conversion. To engage dynamic conversion for K, M and B we need to use an expression. Hope QS incorporates something for this instead of all these workarounds.

paulyeo11
Valued Contributor II

Re: Why QS use G instead of B ?

You suggestion is great , I support you. Hope QS developer view your suggestion.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>