Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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,