Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

Qlik Sense: Default number-abbreviation format for billions is set to 'G'

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Qlik Sense: Default number-abbreviation format for billions is set to 'G'

Last Update:

Jul 27, 2021 8:53:43 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jun 17, 2017 5:06:50 AM

This article states why the default auto number format in sheet objects such as charts is set to K,M,G instead of K,M.B.

1G instead of 1B.png

 

Environment:

Qlik Sense Enterprise on Windows 

 

The default number-abbreviation format for billions is set to the international SI unit of "G".  

 

Resolution:

 

1. You are able to change this beginning in charts using a load script modification.

Use the load script statement and modify to your preference:

SET NumericalAbbreviation='3:k;6:M;9:B;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';



2. You can also change the default that the script generates. 

Do this by adding NumericalAbbreviation=3:k;6:M;9:B;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 to the Settings.ini file located here C:\ProgramData\Qlik\Sense\Engine.

Please review How to modify Qlik Sense Engine's Settings.ini for guidance on editing the Qlik Sense Engine's Settings.ini

Labels (2)
Comments
Moritz
Contributor III
Contributor III

Hi @Sonja_Bauernfeind 

this only seems to work within KPI fields. Is there away, to also adress the NumericalAbbreviation setting within tables?

Thanks,

Moritz

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Moritz 

All charts should be affected by this change. I was able to find an old defect (resolved), which made NumericalAbbreviation not apply to bar charts - but was otherwise not able to reproduce this.

One suggestion I have is to make sure you force the format (as a number) with Num(). 

If it still does not work, please log a support case to have this investigated as a defect. When doing so, include an example application we can use, as well as exactly what version you are using.

All the best,
Sonja 

Moritz
Contributor III
Contributor III

For me it only works within a KPI tile.

Tried with the following set expressions:

Num(Revenue)

As well as Num(Revenue, '#,##0.0A') - thought that A would adrres the NumericalAbbreviation.

 

Here's how I defined that:

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

 

Moritz
Contributor III
Contributor III

@Sonja_Bauernfeind 

which format did you then chose within the Number Formating?

eg.: 

Moritz_0-1707487881524.png

 

 

Moritz
Contributor III
Contributor III

@Sonja_Bauernfeind any thoughts on that? Can it be, this is due to a version difference?

Eventually that we're still on the version, which didn't solve this bug? Which version solved it?

Thanks,

Moritz

Sonja_Bauernfeind
Digital Support
Digital Support

Hello, @Moritz The defect I mentioned was related to bar charts and was fixed in the February 2022 Patch 7 patch (internal investigation ID: QB-9717).

As mentioned before: 

If it still does not work, please log a support case to have this investigated as a defect. When doing so, include an example application we can use, as well as exactly what version you are using.

All the best,
Sonja 

vinieme12
Champion III
Champion III

@Moritz @Sonja_Bauernfeind does this apply to Table/Pivot charts as well??

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @vinieme12 

I asked one of our experts.

For tables, you can use FABS() function to calculate absolute value and then IF to format the sum:

Sonja_Bauernfeind_0-1709568972998.png

 

Then adjust/update this expression to your needs:

IF(FABS(Sum(Value)) > 1000000, num(Sum(Value)/1000000,'#,##0.00 M'),
  if(FABS(Sum(Value)) > 1000, num(Sum(Value)/1000000,'#,##0.00 K'), 
  num(Sum(Value),'#,##0.00')))

For any more detailed questions, please post about your requirement and what you are looking to achieve in the app development forum.

All the best,
Sonja 

Contributors
Version history
Last update:
‎2021-07-27 08:53 AM
Updated by: