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

Wed, 14 Nov 2012 06:15:01 GMT

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

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

Gysbert_Wassenaar — Wed, 14 Nov 2012 09:28:28 GMT

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.

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

Wed, 14 Nov 2012 09:36:01 GMT

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

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

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

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

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