2 Replies Latest reply: Nov 14, 2012 4:36 AM by amitsaini007 RSS

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

      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 IdTags1
      101_CTT_Responsive
      103_CTT_Not Privileged
      104_CTT_Enron Financial Statements (Incl. SEC Filings)
      104_CTT_Communication regarding Enron financial issues
      101_CTT_Enron Securities

       

      This is my Answer Sheet in .xlsx format

       

      Answer:

       

      Doc IdTags2
      101_CTT_Responsive
      103_CTT_Not Privileged
      1xxxx
      1yyyy
      101_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 IdTags1Tags2Result
      No
      101_CTT_Enron Securities01_CTT_Enron SecuritiesYes
      101_CTT_Enron Securities01_CTT_ResponsiveNo
      101_CTT_Enron Securities03_CTT_Not PrivilegedNo
      101_CTT_Enron SecuritiesxxxxNo
      101_CTT_Enron SecuritiesyyyyNo
      101_CTT_Responsive01_CTT_Enron SecuritiesNo
      101_CTT_Responsive01_CTT_ResponsiveYes
      101_CTT_Responsive03_CTT_Not PrivilegedNo
      101_CTT_ResponsivexxxxNo
      101_CTT_ResponsiveyyyyNo
      103_CTT_Not Privileged01_CTT_Enron SecuritiesNo
      103_CTT_Not Privileged01_CTT_ResponsiveNo
      103_CTT_Not Privileged03_CTT_Not PrivilegedYes
      103_CTT_Not PrivilegedxxxxNo
      103_CTT_Not PrivilegedyyyyNo
      104_CTT_Communication regarding Enron financial issues01_CTT_Enron SecuritiesNo
      104_CTT_Communication regarding Enron financial issues01_CTT_ResponsiveNo
      104_CTT_Communication regarding Enron financial issues03_CTT_Not PrivilegedNo
      104_CTT_Communication regarding Enron financial issuesxxxxNo
      104_CTT_Communication regarding Enron financial issuesyyyyNo
      104_CTT_Enron Financial Statements (Incl. SEC Filings)01_CTT_Enron SecuritiesNo
      104_CTT_Enron Financial Statements (Incl. SEC Filings)01_CTT_ResponsiveNo
      104_CTT_Enron Financial Statements (Incl. SEC Filings)03_CTT_Not PrivilegedNo
      104_CTT_Enron Financial Statements (Incl. SEC Filings)xxxxNo
      104_CTT_Enron Financial Statements (Incl. SEC Filings)yyyyNo

       

      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 IdTags1Tags2Result
      No
      101_CTT_Responsive01_CTT_ResponsiveYes
      103_CTT_Not Privileged03_CTT_Not PrivilegedYes
      104_CTT_Enron Financial Statements (Incl. SEC Filings)xxxxNo
      104_CTT_Communication regarding Enron financial issuesyyyyNo

      01_CTT_Enron Securities01_CTT_Enron SecuritiesYes