A bar chart has been setup to have a fully accumulated expression.
The bars does not contain accumulated result for all dimension values. In the example below the accumulated value for Company C is missing for Month Feb.
Compared to the expected chart where accumulated result is presented for each dimension value.
There are two symptoms for this issue, which will be easier to analyze in a Straight Table object.
Convert chart to a straight table for better overview
- Missing dimension value for the missing data point
- Data point has a zero or null result
The best way to analyze the chart setup and data that is being rendered is to turn the chart into a straight table.
Missing dimension value for the missing data pointIn this scenario there is no dimension value representing the missing value. In the example below there is no dimension for the Month Feb and Company C.
- Copy the bar chart object, to enable easily reverting to the original object
- Convert the chart into a Straight Table
- Disable zero-value suppression in Chart Properties > Presentation
- Enable No Accumulation for the expression, to show row by row contribution to the accumulation
- The Straight Table will now show the calculation result which are used to generate the bar chart
All calculations of expression in the chart are done over the dimension values. Without a dimension value there is no placeholder for the calculation. Without a calculated result there is no rendered result. In this scenario the accumulated result in the bar chart is missing, because there is no calculation to base the rendering on.
Data point has a zero or null result
The other possibility is that the straight table show the missing data point, but the data point has zero or null as result.
In this scenario the accumulated result is not rendered due to a product design limitation, that excludes the zero and null results from the accumulation.
This issue was reported as bug 61681, and the concluded limitation will be added in documentation limitation from 11.20 SR10 and forward.
The design limitation is a consequence of other changes made in QlikView 11, and resolving the limitation is consider too high risk.
Depending on the root cause there are different option to resolve the issue. Missing dimension value for the missing data point
Dimension values are listed based on how the expression and selections span over the data model. If the expression is complex and/or contains set expressions, then the expression might be incorrect and thereby excluding the dimension value.
With a correct expression and missing dimension value, there is no easy or quick fix. The only remaining resolution is to evaluate the data model. There needs to be an associated connection between the dimension values and the fields used in the aggregation, so that the expected dimension values get included in the chart. This could be done by insert data into the model to e.g. generate dummy rows to simulate an association, or by redesigning the data model to allow for the expected association.
A possible workaround can be to switch from bar chart to line chart. The line in a line chart is drawn between data points, which will have the visual effect of filling the missing data point.
CAUTION: Redesigning the data model or inserting data to the data model can affect other calculations and associations in the application. Data point has a zero or null result
The limitation related to zero or null result can be avoided by adding an insignificant value to the aggregation.