Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rennesia
Contributor III
Contributor III

Stacked chart from table with missing data

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?

Labels (1)
1 Reply
Brett_Bleess
Employee
Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.