Decimal point in bar chart

[Prinky]

Hi everyone,

Does anyone know why the decimal point of the green bar shows in 3 decimal points? Because the number format of the three bars is also set to automatic (Image 1). According to my experience, usually it will be displayed as two decimal point, but why is the number of green bars displayed with 3 decimal points (Image 2)?

Image 1:

Image 2:

[MayilVahanan]

Hi Prinky,

Can you check the number format in Master Measures once whether 3 decimal points are mentioned?

[Prinky]

Hi MayilVahanan,

Thanks for your reply. I didn't set any number format in the Master Measures.

Please advise.

[Andrei_Cusnir]

Hello,

I was trying to reproduce the same behavior on my side, however I was unable to do so.

If my understanding is correct, you have the following setup:

1. 3 Measure Master Items without any formatting setup. (All 3 Master Items have Number formatting set to Auto)
2. You have created an Bar chart, with Dimension set to Months (Mar, Apr, May)
3. And for Measures, you have used the 3 Measure Master Items that you have created previously
4. The Number formatting for each added measure in the Bar chart is set to "Auto" as well

Please provide the following information:

1. Which edition of Qlik Sense are you using?
2. Which version of Qlik Sense are you using and which patch version (In case it is not a SaaS edition)
3. Was it working before?

In addition to the information requested above, can you also provide the exact values of the measures? To do so, you can enter into "Edit sheet" mode and then go to the measures added in your Bar chart. Instead of using "Auto" for Number formatting, please select "Custom". This will show the exact value that you have for the Measure. So Instead of showing something like 5M, it will show e.g. 5,000,790.00. Please provide the exact value for all the measures.

This information will help me understand better the use case scenario and will allow me to try and reproduce the issue in a right test environment.  

[Prinky]

Hi Andrei_Cusnir,

Thanks for your reply.

Yes. Your understanding is correct.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Here is the answer to your question:

1. Which edition of Qlik Sense are you using?
   • Ans: client-managed
2. Which version of Qlik Sense are you using and which patch version (In case it is not a SaaS edition)
   • Ans: Qlik Sense April 2020 Patch 3
3. Was it working before?
   • Ans: Yes

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If I did not misunderstand, I think the following is your request.

Thanks.

[Andrei_Cusnir]

Hello,

Thank you for sharing this information with us. I tried to reproduce the issue on my side with Qlik Sense April 2020 Patch 3, however I was unable to do so. On my side, everything is working as designed. I also had used Master Item Measures to ensure that I reproduced in a test environment, which is as close to yours as possible. 

Here is the data that I used (As you can see, it is the same as yours):

 

Now you can see that if values are displayed as M, they appears as:

And all of the values have 2 decimal points except one value which is 13,002,804.95 and appears as 13M.

I then have created another Bar chart without using Master Item Measures, but rather use the fields as they are and the outcome didn't change:

As I have mentioned above, I didn't use any formatting in my Bar chart, Master Item measures etc., however I can see that we still have a small difference. My values appears as XX XXX XXX,XX  but your values appear as XX,XXX,XXX.XX. My current hypothesis are:

1. My dataset is just huge values, while your dataset consist of many values that are summed or etc. (at least I assume so). So maybe one of the values in the dataset is breaking the formatting for the total calculated value.
2. There might be some sort of formatting after all either on the Master Item Measure or the Bar chart that you might haven't noticed. Or maybe there was formatting and removed but the configuration remained. 

To proceed further with the investigation of this issue. Please share the following information with us:

1. You have specified that it was working before.
   1. Did you do any changes to the environment? (Upgraded from older version of Qlik Sense etc.)
   2. Did you do any other changes? (Exported the app from other software and imported it into your current one)
2. Can you recreated the Master Items and Bar chart from the beginning, without specifying any formatting to see if the values are displayed differently?
3. Can you create a new Bar chart without using the Master Item Measure and see if the values are displayed differently?

This information will help us understand if the dataset, the visualization or an action that you have performed is causing the issue

[Prinky · Accepted solution]

Hi  Andrei_Cusnir,

I was able to solve this problem by creating a new bar chart with the Master Item Measure.

Thank you very much for your help and suggestions.

[Andrei_Cusnir]

I am glad to hear that you were able to resolve the issue!