Loss of Number Formatting in Bar chart

[ngulliver]

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

[sunny_talwar]

Would you be able to share a sample?

[stevedark · Accepted solution]

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