Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mstoler
Partner - Specialist
Partner - Specialist

Change G abbreviation in KPI object to B for billion

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

2 Replies
jananireddy
Partner - Creator
Partner - Creator

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

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