topic Re: How to compare 2 fields in different tables in QlikView

How to compare 2 fields in different tables

rahulkatte007 — Mon, 16 Sep 2019 11:04:02 GMT

How to write the expression in pivot table to count the field ADDR_NUMBR by comparing the ID field from table1 to table2?

Note: ID column is dimension in Pivot table

Table1

ID	ADDR_NUMBR
1	345
2	654
3	674

Table2

ID	FISVAR
1	QTE
2	ERT
3	FRE

Re: How to compare 2 fields in different tables

dplr-rn — Mon, 16 Sep 2019 16:06:09 GMT

Not clear on what you mean.
if it is 2 different tables; it should be automatically associated and count should work.

Please expand with more details e.g. sample data, data model screenshots etc.

Re: How to compare 2 fields in different tables

Brett_Bleess — Thu, 26 Sep 2019 17:56:32 GMT

Did Dilip's post get you what you needed, or are you still working upon things? If Dilip's post was what you needed, please be sure to come back and use the Accept as Solution button on his post to give him credit and let others know it worked. If you are still working on things, leave an update, and if you did something else, considering sharing that solution and marking it, so others will know that worked.

Regards,
Brett