Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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.

5 Replies
Gysbert_Wassenaar
Not applicable

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')

     ) & ''


talk is cheap, supply exceeds demand
alemberg
Not applicable

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

lakshmikandh
Not applicable

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

psublue98
Not applicable

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!

Gysbert_Wassenaar
Not applicable

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')

    ) & ''


talk is cheap, supply exceeds demand