topic Re: Joins in QlikView

Joins

khadar — Wed, 13 Jul 2022 08:01:06 GMT

Hi Team,

I need small help, can some pls help me out on the logic.

I have 2 tables the out put from table one is input to second table to make count.

for instance

Table1:

load

Type of work ,

TID

from XZY;

Table 2

ID,

location ,

joining date,

month

from ABC;

I want calculate count of TID's that will fall in ID in table2 .

Re: Joins

sidhiq91 — Sun, 17 Jul 2022 02:35:09 GMT

@khadar Could you please try something like below:

Table1:

load

Type of work ,

TID

from XZY;

Inner join (Table1)

Table 2:

Load

ID as TID,

location ,

joining date,

month

from ABC;

Expression to count would be: Count(TID)

If this resolves your issue, please like and accept it as a solution.