Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

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

lakshmikandh
Valued Contributor 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 ***

Comments
jorgebrugos
New 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,

Jorge

johnwatson12
New Contributor

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

0 Likes
vicio
New 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!

Employee
Employee

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

0 Likes
kingsley101
New 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

etc

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

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

etc


Hope this helps!


Thanks

Kingsley

0 Likes
Vince_CH
Contributor II

Hello All,

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

https://community.qlik.com/t5/New-to-Qlik-Sense/Bar-chart-label-format-number-doesn-t-show-correctly...

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!

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2016-09-27 03:18 PM
Updated by: