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