Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Contributor II

Change the representation of G to B for Billion figure

Hi, How can i change the representation of G to B for a billion figure. Although i know that billion is represented as G, but still users in my organization are used to see it as a B.

Any suggestions??

Tags (1)
3 Replies
Highlighted
Not applicable

Re: Change the representation of G to B for Billion figure

This is kind of cheating, but hey, if it works...

if(Sum(A)>=1000000000 and Sum(A)<=999999999999,round(Sum(A)/1000000000,0.01) & 'B', Sum(A))

Highlighted
Luminary
Luminary

Re: Change the representation of G to B for Billion figure

It's not cheating, it's bad practise.

Highlighted
Not applicable

Re: Change the representation of G to B for Billion figure

Fair enough. From these links though it seems that Qlik doesn't actually allow to change the number formatting without changing the javascript (which is banned): 173958, 760274 230923, 558909‌, 166582. So even though it's "bad style" (and it really is), I personally don't see a different option. There could be one though.