Bug in stacked area charts (?)

[Gaël]

Hello,

Is this a bug, or an odd way in thinking of Qlik Sense? See the attached screenshot: all charts should go up to n=4, but the stacked area chart goes way beyond.

1. I create a bar chart of Count({...} distinct OrderID) by ReferenceDate. On the 19/06/2025, n=4. All is good.
2. The corresponding area chart looks the same. It just has a more compact display of the time axis.
3. I copy-paste the bar chart and subdivide the bars by PendingDaysCat (the number of days that an order is pending, categorized), and make it into a stacked bar chart. All is still good.
4. I copy-paste that stacked bar chart and transform it into a stacked area chart, but the stacked areas sum up to 6, higher than the stacked bars! Using Aggr(Count({...} distinct OrderID), [Reference Date], PendingDaysCat) won't help.

What could be the problem? No order is in two categories at any given time. Data for this example are attached. The overview tables show the correct figures.

[Or]

I think your issue here may be the bar chart having a categorical X axis and the line chart has a continuous X axis. In this scenario I believe the Qlik engine will assume the missing dates in the continuous axis for each PendingDaysCat should just continue the area from the previous data point, until it reaches the last date for each PendingDaysCat and drops down. 

Tricky if that's the case... 

[Gaël · Accepted solution]

The correct option hides in the "appearance" tab: "show missing values as 0" instead of joining the non-missing values does the trick. That took me incredibly long to find out.