Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

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
MVP & Luminary
MVP & Luminary

Re: Loss of Number Formatting in Bar chart

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

2 Replies

Re: Loss of Number Formatting in Bar chart

Would you be able to share a sample?

MVP & Luminary
MVP & Luminary

Re: Loss of Number Formatting in Bar chart

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