Qlik Community

Qlik Sense Documents

Qlik Sense documentation and resources.

Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now

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

Showing results for 
Search instead for 
Did you mean: 
Specialist II
Specialist II

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

*** Sorry **** Content is removed as editing the base javascript files is Support License Agreement Violation ***

Contributor II
Contributor II

Hi Michael,

Would you please confirm if that will only work in a pivot table?

When could we expect that be resolved in QlikSense ?

Kind regards,



Below is a solution that we got to work in Qlik Sense in KPIs, tables, and charts. It is not dynamic, in the sense that you need to expose to the users a filter on a field (island in data model) called "Unit", which has text values: Base, Thousands, Millions, Billions, etc. You then create a variable called vUnit, that calculates =IF(ONLY(Unit)='Thousands',1000) .... etc. continuing the if statement. The formula below then switches to B in KPIs, tables, or charts for example.

NUM(SUM([Net Income])/vUnit,IF(vUnit=1,'#,##0',IF(vUnit=1000,'#,##0K',IF(vUnit=1000000,'#,##0M',IF(vUnit=1000000000,'#,##0B')))))

Contributor III
Contributor III

Hi johnwatson12‌,

pay attention, in your solution you replace the value with the label and if you have different units in the same sequence, there is the risk that chart or the sort is not accurate anymore. By the way, the final solution is right here on this page, just sharp your sight and spot the difference. Please be sure to use "The Solution", just in your custom code or extension, as override method, to avoid to infringe the license and the integrity of QlikSense or at least use with discretion to escape from the lawyers of the "igabyte" designer team with their "Guns".

Don't forget to upvote this idea:

1 month ago, the feedback was valued by the igabyte (or igahertz?) team, the fix requires 2-3 minutes. Perhaps, we will get in the next minor release! Yahoo!


this can now be achieved by simply modifying the set statement in themetric.PNGits simple and easy and takes a few seconds you can change the symbols to anything you like .. from April 2018 release

Contributor III
Contributor III

Hi Everyone.

To change the billions abbreviation in Qlik Sense, follow these steps:

Go to your load editor

Go to your Main section

The last SET expression is what you want to manipulate (Change G to B)

     SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

3:k = 1000

6:M = 1 000 000


-3:m = 0.001          (this will display as 1m)

-6:μ = 0.000001     (this will display as 1μ)


Hope this helps!



Creator II
Creator II

Hello All,

I have a similar issue in bar chart legend number format , as following post:


Having tried to remove num funtion in measure expression and put it on measure number format by customs. or with auto number, it can show K or M in bar graph well unfortunately without currency mark set in front. To use the '3:k;6:M;...' also was tried but didn't work out. 

My problem is, that the legend number format keeps in 2.71k, while on the bar chart it was 2,706K. 

Can you help me out how to make them in consistency? thanks!

Version history
Last update:
‎2016-09-27 03:18 PM
Updated by: