Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Contributor II
Contributor II

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

Highlighted
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

Highlighted
Contributor III
Contributor III

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!

Highlighted
MVP & Luminary
MVP & Luminary

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