Change G abbreviation in KPI object to B for billion

[mstoler]

Hello,

when I use the KPI object and the amount is in Billions Qlik Sense abbreviates it with a G.

Can I change this to B for Billion?

Thank You,

Michael

[jananireddy]

Hello,

The only why right now is to divide your value by 1000000 and apply this custom format " # ##0,00 M" in the measure's number setting.

There is no global setting in the App when you can change the format, although i wish it was there.

Hope this helps your query!

[jasoncline_13]

I realize this is a very old post, but in case anyone lands here trying to figure this out, change the NumericalAbbreviation property on the main tab in the load editor. E.G. 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';