Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Yeah, your data model sucks 
Well, probably not. I haven't seen it obviously. Two things you could look into are:
- concatenate the errors and successes tables into one table
- create a link table for the hour dimension
The first option would be preferable. But perhaps the questions your qlikview app must answer makes this impractical.
The second option would load all the hour values from the errors table into the hours link table and then also add all the hour values from the successes table. You would have to rename the hour fields to make sure the errors and successes table associate with the link table only and not with each other. Creating the link table would look something like this:
Hours:
load Hour, Hour as ErrorHour from errors.qvd (qvd);
load Hour, Hour as SuccessHour from successes.qvd (qvd);
Errors:
Load ...some fields... , Hour as ErrorHour from errors.qvd (qvd);
Successes
Load ...some fields... , Hour as SuccessHour from successes.qvd (qvd);
Pier Domenico Muzzi wrote:
...
How can I visualize all successes and errors in the same chart?
...
If I were Gysbert Wassenaar, I'd answer - by building a better data model.
Seriously - there is no enough information to answer your question, except it looks like something is wrong with your data model. You have to upload your application if you need a better answer 
Yeah, your data model sucks
Well, probably not. I haven't seen it obviously. Two things you could look into are:
- concatenate the errors and successes tables into one table
- create a link table for the hour dimension
The first option would be preferable. But perhaps the questions your qlikview app must answer makes this impractical.
The second option would load all the hour values from the errors table into the hours link table and then also add all the hour values from the successes table. You would have to rename the hour fields to make sure the errors and successes table associate with the link table only and not with each other. Creating the link table would look something like this:
Hours:
load Hour, Hour as ErrorHour from errors.qvd (qvd);
load Hour, Hour as SuccessHour from successes.qvd (qvd);
Errors:
Load ...some fields... , Hour as ErrorHour from errors.qvd (qvd);
Successes
Load ...some fields... , Hour as SuccessHour from successes.qvd (qvd);