Association behavior of Qlikview - Missing values

[#1]

Hi QVers,

I'm confused by the association behavior of Qlikview, here is my situation:

I have 4 tables, Table 1 to 4. They are joined by 4 fields by the field name:

Table 1: A, B

Table 2: B, C, D

Table 3: B, C, D

Table 4; A, C

Here is the observation:

1) For table 3, For those B not in Table 4, C is set to null in qlikview although it originally have values

2) Missing values of A: the list of A I got in Qlikview is 80 distinct A but I have 500+ distinct A in Table 4. After a checking, I found out the list of 80 came from

     A of Table 1 (20) inner join with Table 4, which results in (18 A)

      union B of Table 2 with field C inner join with Table 4, which results in (63 A).

However, Table 3 is not counted here, as B of Table 3 with field C inner join with Table 4 will results in (400+ A)

This cause the missing values of A in my worksheet as most of the summary data are calculated from Table 3 but the list of A is not complete.

Can anyone tell me what is happening here and how can I solve the problem?

Thanks very much!

Best Regards,

Crystal

[jagan]

Hi,

What is the script you used?  What are the other columns in tables?  Why can't you try concatenate?

Data:

LOAD

*

FROM Table1;

Concatenate(Data)

LOAD

*

FROM Table2;

Concatenate(Data)

LOAD

*

FROM Table3;

Concatenate(Data)

LOAD

*

FROM Table4;

Hope this helps you.

Regards,

Jagan.

[sushil353]

Hi,

post your script for better understanding.

~Sushil

[jonathandienst]

Hi

It looks like a problem in the way you are joining the tables. The structure you explain contains a loop, which Qlikview will break by loosely coupling one of the tables.

I suggest that you post the script that you are using.

HTH

Jonathan

[#5]

Hi Jonathan,

Yes, the structure contains a loop, I recheck the structures, in order to break the loop, I add A into Table 2, therefore

Table 2: A, B, C, D

the script didn't have the fields name as I control them in the sql views.

Many thanks,

Crystal