Count joined tables

[CatalinDorobantu]

Hi,

I am having two tables loaded in QlikSense, they are associated by CallID column.

Table A(Product, CallID, Date)

Table B(Product, CallID, Date)

I want to count all calls by Product in Table A, all calls by Product in table B and all calls from the intersection.

Hope I was clear enough.

thank you!

[Lisa_P]

Are they loaded into two tables ? They would automatically concatenate to become one table. You could add another field in the load script to differentiate them like this:
[Table A]:
Load Product,
CallID,
Date,
'Table A' as Table
...
and the same for Table B, they would concatenate to one table, but you could then use the table field to differentiate between them.