Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
robert_mika
Master III
Master III

Because billion has different meanings:

US - 1 and nine zeros

UK - 1 and 12 zeros

G is international abbreviation

View solution in original post

6 Replies
robert_mika
Master III
Master III

Because billion has different meanings:

US - 1 and nine zeros

UK - 1 and 12 zeros

G is international abbreviation

soniahelm
Partner - Contributor
Partner - Contributor

Can the G be converted to a B?

vlad_komarov
Partner - Specialist III
Partner - Specialist III

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

VK

soniahelm
Partner - Contributor
Partner - Contributor

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

sri_c003
Partner - Creator II
Partner - Creator II

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
Master
Master
Author

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>