Stacked chart from table with missing data

[rennesia]

Hi,
The problem is creating a chart from a table with missing data.  At a certain timestamp I have seperate data rows for all  values. I have to combine them in a stacked chart. The null values has to be ignored. In the attached picture I show data for one timestamp.
Is there a way to realize this without changing the data table?

[Brett_Bleess]

Here area a couple of Design Blog posts that may be of some further help, but I think you are going to need to replace the Nulls with 0 in order to be able to have things work out, but I am not certain.

https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674

https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279

Sorry I do not have something better for you.

Regards,
Brett