topic Re: Comparing 2 tables - not working -- in QlikView https://community.qlik.com/t5/QlikView/Comparing-2-tables-not-working/m-p/334121#M1177300 <HTML><HEAD></HEAD><BODY><P>This is easier to see I think</P><P></P><P>Thanks</P></BODY></HTML> Thu, 03 May 2012 10:03:23 GMT 2012-05-03T10:03:23Z Comparing 2 tables - not working -- https://community.qlik.com/t5/QlikView/Comparing-2-tables-not-working/m-p/334120#M1177299 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>Please help --</P><P></P><P>I have 2 tables which I wish to compare for matches. I have created Unique Identifiers [SearchNos] on each and now wish to create charts when the unique identifier is common for both tables.</P><P></P><P>Can you please have a look at screen shot and explain why its not working how Id like.</P><P></P><P>I wish for it to only count the first row where SearchNo = SearchNo1, yet it is counting both !</P><P><BR />Can anyone please advise ?</P><P></P><P>Thanks</P><P><BR />A</P><P></P><P><IMG alt="Error 1.bmp" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/13750_Error+1.bmp" width="450" /></P></BODY></HTML> Thu, 03 May 2012 10:01:33 GMT https://community.qlik.com/t5/QlikView/Comparing-2-tables-not-working/m-p/334120#M1177299 2012-05-03T10:01:33Z Re: Comparing 2 tables - not working -- https://community.qlik.com/t5/QlikView/Comparing-2-tables-not-working/m-p/334121#M1177300 <HTML><HEAD></HEAD><BODY><P>This is easier to see I think</P><P></P><P>Thanks</P></BODY></HTML> Thu, 03 May 2012 10:03:23 GMT https://community.qlik.com/t5/QlikView/Comparing-2-tables-not-working/m-p/334121#M1177300 2012-05-03T10:03:23Z Comparing 2 tables - not working -- https://community.qlik.com/t5/QlikView/Comparing-2-tables-not-working/m-p/334122#M1177301 <HTML><HEAD></HEAD><BODY><P><STRONG><SPAN style="color: #008000; font-size: 8pt;"> </SPAN><SPAN style="color: #008000; font-size: 8pt;"> </SPAN><SPAN style="color: #008000; font-size: 8pt;">Count(if(SearchNo=SearchNo1,SearchNo))</SPAN></STRONG></P><P></P><P><STRONG style=": ; color: #008000; font-size: 8pt;">So easy Its scary how it took me so long to figure out _+im a little embarrassed</STRONG></P><P></P></BODY></HTML> Thu, 03 May 2012 11:10:01 GMT https://community.qlik.com/t5/QlikView/Comparing-2-tables-not-working/m-p/334122#M1177301 2012-05-03T11:10:01Z