topic NumericalAbbreviation does not work with bar charts in Qlik Sense Feb 2022 release version? in App Development

NumericalAbbreviation does not work with bar charts in Qlik Sense Feb 2022 release version?

Uttamjit — Wed, 17 Aug 2022 01:37:34 GMT

I am trying to change the NumericalAbbreviation variable to denote a billion with "B" instead of "G".

I have tried updating this in load script as well as Settings.ini files on server, but it seems like the bar charts are not picking up this setting. The KPIs, combo charts and Line chart seem to pick up the setting fine. I found this problem with Feb 2022 release, because the same app does seem to work on older version of Qlik Sense (November 2021 release).

Does anyone have an idea if this is actually a bug with Feb 2022 release?

This is what I have in my Load script:

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

App snippet: Green looks good, but Red is still referring to billion as G

Re: NumericalAbbreviation does not work with bar charts in Qlik Sense Feb 2022 release version?

Mark_Little — Wed, 24 Aug 2022 06:24:13 GMT

Hi @Uttamjit

From what you are showing it appears to be a bug, I would log in with support.

Re: NumericalAbbreviation does not work with bar charts in Qlik Sense Feb 2022 release version?

Mario_De_Felipe — Thu, 25 Aug 2022 06:08:39 GMT

Hi @Uttamjit ,

try to force format using Num() in your expression.

Best regards.