topic Re: How to count same records from two tables in QlikView

How to count same records from two tables

rkpatelqlikview — Tue, 30 Jan 2018 04:03:10 GMT

can anyone please give me a clarity on this.

Please find the attached sample document.

There are 2 tables. One is Sub and another is Master.

Sub table having the fields Tid, Vnum, Status, Dnum,Date.

Master table is having fields Dnum, Vnum, Date. This Master table having all the missed Dnum's from Sub.

Sub table is missed some Dnum's.

I need to count the number of entries of Dnum's with Sub and with out Sub from the Master table.

Please suggest.

Thanks in advance.

karthikoffi27se — Tue, 30 Jan 2018 04:36:37 GMT

Hi Kumar,

You can concatenate two tables and then count the Dnum's. This will give the count from two tables.

Many Thanks

Karthik

rkpatelqlikview — Tue, 30 Jan 2018 05:23:40 GMT

Thanks for your quick response Karthik.

Need to count matched Dnum's and Unmatched Dnum's from the both tables.

how to achieve this?

After concatination its showing like below Nulls.

arvind1494 — Tue, 30 Jan 2018 05:35:01 GMT

count(master.Dnum)-count(sub.Dnum) will give you entries without sub

and

count(sub.Dnum) will give entries with a sub

tamilarasu — Tue, 30 Jan 2018 05:59:37 GMT

Hello Kumar,

Please look at the attached file and let us know whether this is your requirement or not.

techvarun — Tue, 30 Jan 2018 06:01:33 GMT

Please check the attached helps.

If not share the expected results

rkpatelqlikview — Tue, 30 Jan 2018 08:41:52 GMT

Correct one. Thanks for your support

43918084 — Tue, 03 Mar 2020 06:15:32 GMT

Would you mind to share the file Comm-289555.qvw for this solution?