I am having the following issue / problem and would like to get clarity about.
I have two tables from CSV imported, say Europe and Asia Data. In both tables the most columns are the same. The column for amounts of sold items in Europe is: SOLD_EU, in Asia tables the sum is called: SOLD_ASIA. Additionally in Asia, there is a column: RETURNED.
By importing the tables now, i got a SOLD_EU table, a SOLD_ASIA table and a SYNC table.
Now I have graphs in my qlikview. The one shows the sum of SOLD_EU items, the other one shows the sum of SOLD_ASIA items.
When I choose now a sales person, both graphs give me a perfect overview by selecting the sales person from the SYNC table. Both SUMs are calculated correctly.
When I now do select additionally RETURNED = YES (keep in mind the RETURNED just exists in the SOLD_ASIA table), it reduces the number for the asia graph correctly to the returned onces BUT it also reduces the sum of the SOLD_EU items.
Now the question:
Why has the filter RETURNED = YES influence on the SOLD_EU table. I thought as the column is not existing in SOLD_EU it will not be taken into account. And I don't get what qlikview filters in SOLD_EU table.
Thanks for any hint, pushing my into the correct direction.
Most likely because the sync table holds common fields, so filtering out returned='YES', eliminates field values from common columns so SOLD_EU is influenced as well.
For example :
SOLD_UD
name sold
A 100
B 100
SOLD_ASIA
name sold returned
A 120 YES
C 130 -
If you apply retruned='YES' you end up with A client only for both tables since they are connected via name because of the sync table.
If you post your document, maybe I can be more helpful.
