Stacked chart from table with missing data

rennesia — Sat, 16 Nov 2024 18:49:48 GMT

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?

Re: Stacked chart from table with missing data

Brett_Bleess — Wed, 29 Apr 2020 13:53:40 GMT

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

topic Re: Stacked chart from table with missing data in QlikView

Stacked chart from table with missing data

Re: Stacked chart from table with missing data