Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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';