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: 
ngulliver
Partner - Specialist III
Partner - Specialist III

Loss of Number Formatting in Bar chart

Hi,

I have an issue where the number formatting on a stacked bar chart is lost.

The bar chart has 6 expressions - I have double checked to make sure each expression has the number formatted fixed to 2 decimal places and shown as a percentage.

The dimension is a drill down group  from MonthYear to DayMonthYear

At the top level, the vertical axis shows the data with the correct format. When select a specific day, I drill down from MonthYear to DayMonthYear and lose the formatting. However, the pop-up data values remain correctly formatted.

Has anyone else seen this happen and what causes it ? Is it an issue with drill down groups ?

Regards,

Neil

p.s. I am using QV v11 SR7

1 Solution

Accepted Solutions
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I believe this may be due to the fact that your stacked bars are based on multiple expressions, rather than on a secondary dimension.

If the first expression returns null when drilled into one of the months then QlikView will attempt to use this null value to determine which number format it should use.  Obviously, with a null value it will fail.

Putting an Alt statement around each expression should fix the issue.

Steve

View solution in original post

2 Replies
sunny_talwar

Would you be able to share a sample?

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I believe this may be due to the fact that your stacked bars are based on multiple expressions, rather than on a secondary dimension.

If the first expression returns null when drilled into one of the months then QlikView will attempt to use this null value to determine which number format it should use.  Obviously, with a null value it will fail.

Putting an Alt statement around each expression should fix the issue.

Steve