topic Re: Chart's data loss while linking tables in QlikView

Chart's data loss while linking tables

Wed, 09 Apr 2014 11:15:58 GMT

Hi guys.

I'm back for another issue in QlikView.

I'm implementing a log analyzer that compares accesses and errors logs.

I've stratified my app into two separate layers: in the lower layer I'm retrieving all the records from my datasource creating two different qvd (errors and successes) and in the upper one (the dashboard) I'm creating all the tables needed for my analysis linking them by hour as dimension.

The analysis consists in compare how many errors and successes occurs in an hour. Obviously I can have successes and no errors and viceversa at same hour but in the chart appears only successes and errors occurred at the same hour. How can I visualize all successes and errors in the same chart?

Thank a lot.

Re: Chart's data loss while linking tables

Thu, 10 Apr 2014 12:44:37 GMT

Re: Chart's data loss while linking tables

Anonymous — Thu, 10 Apr 2014 20:31:00 GMT

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

Re: Chart's data loss while linking tables

Gysbert_Wassenaar — Fri, 11 Apr 2014 09:39:24 GMT

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);

Re: Chart's data loss while linking tables

Mon, 14 Apr 2014 15:50:40 GMT

Wonderful!!!

It works great! I was wrong to link tables with only one common key (Hour).

Thanks a lot for your time and response.