How to Compare two feilds if Doc Id is same...Please help urgent

[#1]

Hi Friends..!!!

I am facing here a serious problem while compairing Master Sheet with answer Sheet having same Doc Id .

This is my Master sheet in .xlsx format

Master:

Doc Id	Tags1
1	01_CTT_Responsive
1	03_CTT_Not Privileged
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)
1	04_CTT_Communication regarding Enron financial issues
1	01_CTT_Enron Securities

This is my Answer Sheet in .xlsx format

Answer:

Doc Id	Tags2
1	01_CTT_Responsive
1	03_CTT_Not Privileged
1	xxxx
1	yyyy
1	01_CTT_Enron Securities

After uploading these two sheets in qlikview with the help of straight table i want to compare Tags1(Master) with Tags2(Answer).

Result After Comparision in Straight Table:

Doc Id	Tags1	Tags2	Result
			No
1	01_CTT_Enron Securities	01_CTT_Enron Securities	Yes
1	01_CTT_Enron Securities	01_CTT_Responsive	No
1	01_CTT_Enron Securities	03_CTT_Not Privileged	No
1	01_CTT_Enron Securities	xxxx	No
1	01_CTT_Enron Securities	yyyy	No
1	01_CTT_Responsive	01_CTT_Enron Securities	No
1	01_CTT_Responsive	01_CTT_Responsive	Yes
1	01_CTT_Responsive	03_CTT_Not Privileged	No
1	01_CTT_Responsive	xxxx	No
1	01_CTT_Responsive	yyyy	No
1	03_CTT_Not Privileged	01_CTT_Enron Securities	No
1	03_CTT_Not Privileged	01_CTT_Responsive	No
1	03_CTT_Not Privileged	03_CTT_Not Privileged	Yes
1	03_CTT_Not Privileged	xxxx	No
1	03_CTT_Not Privileged	yyyy	No
1	04_CTT_Communication regarding Enron financial issues	01_CTT_Enron Securities	No
1	04_CTT_Communication regarding Enron financial issues	01_CTT_Responsive	No
1	04_CTT_Communication regarding Enron financial issues	03_CTT_Not Privileged	No
1	04_CTT_Communication regarding Enron financial issues	xxxx	No
1	04_CTT_Communication regarding Enron financial issues	yyyy	No
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)	01_CTT_Enron Securities	No
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)	01_CTT_Responsive	No
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)	03_CTT_Not Privileged	No
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)	xxxx	No
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)	yyyy	No

As Doc Id is same i.e 1 it is showing 25  results instead of 5 results as my Tags consist of 5 entries only. I don't know why my output is coming like this.

Please help me out guys i want my Result should come as mentioned below:

Doc Id	Tags1	Tags2	Result
			No
1	01_CTT_Responsive	01_CTT_Responsive	Yes
1	03_CTT_Not Privileged	03_CTT_Not Privileged	Yes
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)	xxxx	No
1	04_CTT_Communication regarding Enron financial issues	yyyy	No
	01_CTT_Enron Securities	01_CTT_Enron Securities	Yes

[Gysbert_Wassenaar]

From your data there is no way for qlikview to know that xxxx should be matched with 04_CTT_Enron Financial Statements (Incl. SEC Filings) and that yyyy should be matched with 04_CTT_Communication regarding Enron financial issues. From what you posted you're using an implicit order to match the tags. I've made that implicit ordering explicit in the attached qvw.

[#3]

Hi

I can calculate result in straight table by using this:

if(Tags1=Tags2,'Yes','No')

The problem which i am facing is instead of 5  i am getting 25 outputs in result.Could you please help me ....???

Doc Id	Tags1	Tags2	Result
			No
1	01_CTT_Responsive	01_CTT_Responsive	Yes
1	03_CTT_Not Privileged	03_CTT_Not Privileged	Yes
1	04_CTT_Enron Financial Statements (Incl. SEC Filings)	xxxx	No
1	04_CTT_Communication regarding Enron financial issues	yyyy	No
1	01_CTT_Enron Securities	01_CTT_Enron Securities	Yes