topic Bug in Bar Chart - Qlik Sense server:14.54.2 in App Development

Bug in Bar Chart - Qlik Sense server:14.54.2

muhammedraleen — Fri, 15 Nov 2024 21:58:46 GMT

Hi All,

I have changed the default Numerical Abbreviation of 9:G as 9:B. It is working perfectly in all the available list of charts except in the bar chart.

Only in bar chart it shows in G, I have attached it also.

I need to fix it as soon as possible...

Thank you

Re: Bug in Bar Chart - Qlik Sense server:14.54.2

Marijn — Tue, 21 Mar 2023 14:42:58 GMT

Hi,
Did you try changing the number format in the expression in the barchart itself? You can customize it in the chart too, so that might be your (quick) solution

Re: Bug in Bar Chart - Qlik Sense server:14.54.2

muhammedraleen — Wed, 22 Mar 2023 07:56:04 GMT

Hi @Marijn ,

Can you help me on customizing the number format in the expression. To the show value in Billions.

Thank you

Re: Bug in Bar Chart - Qlik Sense server:14.54.2

Marijn — Wed, 22 Mar 2023 08:07:31 GMT

Maybe you'll find your solution here:
https://community.qlik.com/t5/New-to-Qlik-Sense/Rename-G-to-B-in-Qlik-Sense/td-p/82992
or here:
https://community.qlik.com/t5/New-to-Qlik-Sense/Million-symbol-in-Qlik-Sense/m-p/892570

Re: Bug in Bar Chart - Qlik Sense server:14.54.2

muhammedraleen — Wed, 22 Mar 2023 08:30:16 GMT

Hi @MarijnMarijn,

The last link you shared has the way how to customize it... Thank you for the information.

Issue I have here is, I have 5 measures added to it. If I customize the first measure to B, then bar is shown very smaller. In my case, What I need is, the chart should be same as below, only that G, should be shown as B.

Re: Bug in Bar Chart - Qlik Sense server:14.54.2

Marijn — Wed, 22 Mar 2023 09:20:23 GMT

I can't replicate the problem in my own QlikSense environment, it correctly uses the B abbreviation in the barchart (and any other charts). I used this as setting:
NumericalAbbreviation='3:t;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';

I have exhausted my knowledge about this subject. I think there might be a bug if you've already changed the numerical abbreviation and the number format in the chart itself. That, or we are overlooking another option for settings.
Maybe someone from Qlik support can help?