how to retrive possiable values between two tables

[david_ze]

hi All,

will appriciate your help in the following:

I have two table:

Table A: ID, Session_id, Customer

Table B: ID, Session_id, Product

I'd like to count all products inhich the session_id accures in both tables.

I understand it should be using Set Analysis - but ....

Will appreciate your help.

Thanks in advanced.

David

[Oleg_Troyansky]

The fact that you have 2 identical keys, makes this question a bit more complex, but ... I'd try something like this:

"search for those Products that have associated Customers":

count({<Product={"=len(trim(Customer))>0"}>} distinct Product)

[david_ze]

hi Oleg,

Thanks for the reply, but I can't understend how this answers my question.

I would like to count only the products that has associated sessions_id with the customer table.

(regarding the ID I can omit it...)

David

[Oleg_Troyansky]

David,

this is the essence of QlikView association logic - if your Products and Customers are linked via Session ID, then for each Product, the associated Customers are those that the Product's Session ID exists in the Session/Customers table (or else they wouldn't be associated)

hope it helps,