100% Stacked Bar Chart

[mato32188]

Hi guys,

I would like to ask you whether is possible to feed bars to 100% using stacked bar chart with the data provided in attachment. Iow,  I would like to get rid of "grey" sections in bars highlighted in yellow. I am not able to modify expression to get desired result.

The following expression is Sum(Employees) / Sum(total <Year-Month> Employees)

Thank you for your help.

M

[stevejoyce · Accepted solution]

This is a result of limitation on number of dimensional values being displayed, not your calculation.  See below link:

Bar chart ‒ Qlik Sense on Windows

Displaying large amounts of data in a stacked bar chart

When displaying large amounts of data in a stacked bar chart, there may be cases when not each dimension value within a bar is displayed with correct color and size. These remaining values will instead be displayed as a gray, striped area. The size and total value of the bar will still be correct, but not all dimension values in the bar will be explicit.

To remove the gray areas, you can either make a selection or use dimension limits in the properties panel.

The approximate limit for how many stacked bars that can be displayed without gray areas is 5000 bars, assuming that each bar consists of 10 inner dimension values and one dimension value and one measure value for the whole bar.

The initial data load is 500 dimension values or dimension stacks. (The value 500 refers to the outer dimension values, not each dimension value in a stack.) When you have scrolled past those 500 values, an incremental load is performed, where values are instead loaded based on the current view or scroll position.