Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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
Contributor III
Contributor III

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
Specialist II
Specialist II

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

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

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