topic Re: Count joined tables in QlikView

Count joined tables

CatalinDorobantu — Mon, 01 Jul 2019 12:29:00 GMT

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!

Re: Count joined tables

Lisa_P — Tue, 02 Jul 2019 01:19:16 GMT

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.