Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
post your script for better understanding.
~Sushil
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
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