topic Re: Sync Table, reduces numbers in QlikView

Sync Table, reduces numbers

Tue, 26 Jun 2012 13:56:47 GMT

Hello together,

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.

Mathias

Re: Sync Table, reduces numbers

giakoum — Tue, 26 Jun 2012 14:05:40 GMT

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.

Re: Sync Table, reduces numbers

Tue, 26 Jun 2012 14:28:38 GMT

Hi Ioannis, thanks. That explained exactly what I was wondering about.

Do I have any chance to include something in the Set Expression for the SUM function of table SOLD_EU to get each time all results?

Thanks,

Mathias

Re: Sync Table, reduces numbers

giakoum — Tue, 26 Jun 2012 14:43:25 GMT

sum({$<[RETURNED]=>} [SOLD_EU])

or something like that depending on your fields.

Sync tables is really bad practice, you better get rid of them. Try renaming fields or concatenating the two tables.

Re: Sync Table, reduces numbers

Tue, 26 Jun 2012 14:57:39 GMT

you made my day! Thanks so much!