topic Re: Compare two fields in QlikView https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478830#M693253 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P><EM>BirthAddress:</EM></P><P><EM>LOAD</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BirthAddress</EM></P><P><EM>Resident</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UserAddress</EM></P><P><EM>Where BirthAddress=PresentAddress;</EM></P><P></P><P></P><P>not sure is this your requirement.</P></BODY></HTML> Thu, 08 Aug 2013 19:39:43 GMT gajapathy74 2013-08-08T19:39:43Z Compare two fields https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478828#M693251 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I would like to</SPAN> <SPAN class="hps">compare two</SPAN> <SPAN class="hps">fields</SPAN> <SPAN class="hps">within a</SPAN> <SPAN class="hps">table.</SPAN><BR /><BR /><SPAN class="hps">example</SPAN><SPAN>:</SPAN><BR /><BR /><SPAN class="hps">Bring</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">only when</SPAN> <SPAN class="hps">X</SPAN> <SPAN class="hps">equals</SPAN> <SPAN class="hps">Y</SPAN></SPAN></P></BODY></HTML> Thu, 08 Aug 2013 19:25:25 GMT https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478828#M693251 2013-08-08T19:25:25Z Re: Compare two fields https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478829#M693252 <HTML><HEAD></HEAD><BODY><P>That is doable.</P><P></P><P>if(Fieldx =FieldY, Field C) as Field C</P><P></P><P>this will only load Field C if X =Y.&nbsp; </P><P></P><P>If they don't equal, the value will be null.</P></BODY></HTML> Thu, 08 Aug 2013 19:32:53 GMT https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478829#M693252 ryanhicks 2013-08-08T19:32:53Z Re: Compare two fields https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478830#M693253 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P><EM>BirthAddress:</EM></P><P><EM>LOAD</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BirthAddress</EM></P><P><EM>Resident</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UserAddress</EM></P><P><EM>Where BirthAddress=PresentAddress;</EM></P><P></P><P></P><P>not sure is this your requirement.</P></BODY></HTML> Thu, 08 Aug 2013 19:39:43 GMT https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478830#M693253 gajapathy74 2013-08-08T19:39:43Z Re: Compare two fields https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478831#M693254 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">Thanks,</SPAN> <SPAN class="hps">it really worked</SPAN></SPAN></P></BODY></HTML> Thu, 08 Aug 2013 19:45:05 GMT https://community.qlik.com/t5/QlikView/Compare-two-fields/m-p/478831#M693254 2013-08-08T19:45:05Z