5 Replies Latest reply: Jan 25, 2017 1:20 AM by Gysbert Wassenaar

# How to use 'B' for Billion in QlikSense?

Hi,

I am supposed to use 'B' instead of 'G' that appears in KPI when value exceeds billion. There is a similar question posted already in this link. But no one has answered. I am wondering if anyone knows- how to do this?

Thanks.

• ###### Re: How to use 'B' for Billion in QlikSense?

See this discussion: Re: Qlik Sense KPI Number Format Auto

=pick(ceil(log10(sum(Sales))/3),

num(sum(Sales),'#,##0.0'),

num(sum(Sales)/1000,'#,##0.0 K'),

num(sum(Sales)/1000000,'#,##0.0 M'),

num(sum(Sales)/1000000000,'#,##0.0 B')

) & ''

• ###### Re: How to use 'B' for Billion in QlikSense?

Hi Gysbert,

Could this be expanded to override the other qlik numerical label conventions such as µ and m used in a map legend when the values are very small? I'd rather show the decimal values or even scientific notation than use these labels since most people don't understand what they mean in regards to the number format.

Thanks!

• ###### Re: How to use 'B' for Billion in QlikSense?

Perhaps something like this:

=pick(ceil(log10(sum(Sales))/3)+3,

num(sum(Sales)*1000000000,'#,##0.0 n'),

num(sum(Sales)*1000000,'#,##0.0 µ'),

num(sum(Sales)*1000,'#,##0.0 m'),

num(sum(Sales),'#,##0.0'),

num(sum(Sales)/1000,'#,##0.0 K'),

num(sum(Sales)/1000000,'#,##0.0 M'),

num(sum(Sales)/1000000000,'#,##0.0 B')

) & ''

• ###### Re: How to use 'B' for Billion in QlikSense?

I agree, and even though the workaround expressions are doable. They must be done on each visualization. Why cant we simply change this at the INI or code level to address this on a macro level. It is just one letter sitting somewhere...

• ###### Re: How to use 'B' for Billion in QlikSense?

Hi,

You can change the auto number formatting symbol from "G" to "B" in javascript

Please check this Steps to Change : Qlik Sense - Billions number format 'G' to 'B'

Thanks,

Lakshmikandh