Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor

Comparing Data in two tables

I am trying to determine the best way of comparing or joining two tables to get some requested data. I have two tables both with an ID field and Date field and in Table Two I also have a record count. What I need is a way of knowing the sum of record count and count of batch ID when the ID field and Date field in Table 1 and Table 2 match. I can do this easily with SQL but I need to do this in Qlik from the two QVD tables I have created from base text report data. 

1 Reply
Valued Contributor

Re: Comparing Data in two tables

You'd do it in a very similar way loading form qvd as SQL
LOAD ID, Date, Count(ID)
FRom table1
group by ID,Date;
LOAD ID,Date,RecordCount
FROM table2