topic Comparing in QlikView https://community.qlik.com/t5/QlikView/Comparing/m-p/306029#M1200708 <HTML><HEAD></HEAD><BODY><P>QlikView thinks 0001 and 01 are the same because they are. Since they look like numbers, QlikView makes them numbers. Change your two original loads to force a string:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Tab1:<BR />Load Text(ID) As ID, Name Inline [<BR />ID, Name<BR />0001, Carl<BR />0201, Thomas<BR />041017, Pete<BR />080312, Sven<BR />05, Carmen<BR />0510, Tony<BR />5010, Carlo<BR />5101, Paul<BR />2012, Hans<BR />020120, Troy<BR />0121, Michael<BR />00010, David<BR />];<BR /><BR />Tab2:<BR />Load Text(ID) As ID, Name Inline [<BR />ID, Name<BR />01, Carl<BR />0201, Tomas<BR />041017, Pete<BR />080314, Sven<BR />05, Carmen<BR />0510, Tony<BR />5010, Carlo<BR />0521, Paul<BR />2012, Hans<BR />020120, Troyy<BR />0121, Michael<BR />00100, David<BR />0711, Ben<BR />9012, Tim<BR />];</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 14 Feb 2011 17:43:30 GMT 2011-02-14T17:43:30Z Comparing https://community.qlik.com/t5/QlikView/Comparing/m-p/306028#M1200707 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I am having problems comparing data, numbers and strings.<BR />It's numbers that I am having problems with.<BR />Qlikview thinks 0001 and 01 are the same.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">[Missing in Tab1]:<BR />LOAD *<BR />Resident [Tab2]<BR />Where not Exists([Tab1.ID], [Tab2.ID]);</PRE><BR /><BR /> <P>Any thought on how to do the comparision?</P><P>Thanks</P></BODY></HTML> Mon, 14 Feb 2011 17:31:04 GMT https://community.qlik.com/t5/QlikView/Comparing/m-p/306028#M1200707 qw_johan 2011-02-14T17:31:04Z Comparing https://community.qlik.com/t5/QlikView/Comparing/m-p/306029#M1200708 <HTML><HEAD></HEAD><BODY><P>QlikView thinks 0001 and 01 are the same because they are. Since they look like numbers, QlikView makes them numbers. Change your two original loads to force a string:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Tab1:<BR />Load Text(ID) As ID, Name Inline [<BR />ID, Name<BR />0001, Carl<BR />0201, Thomas<BR />041017, Pete<BR />080312, Sven<BR />05, Carmen<BR />0510, Tony<BR />5010, Carlo<BR />5101, Paul<BR />2012, Hans<BR />020120, Troy<BR />0121, Michael<BR />00010, David<BR />];<BR /><BR />Tab2:<BR />Load Text(ID) As ID, Name Inline [<BR />ID, Name<BR />01, Carl<BR />0201, Tomas<BR />041017, Pete<BR />080314, Sven<BR />05, Carmen<BR />0510, Tony<BR />5010, Carlo<BR />0521, Paul<BR />2012, Hans<BR />020120, Troyy<BR />0121, Michael<BR />00100, David<BR />0711, Ben<BR />9012, Tim<BR />];</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 14 Feb 2011 17:43:30 GMT https://community.qlik.com/t5/QlikView/Comparing/m-p/306029#M1200708 2011-02-14T17:43:30Z Comparing https://community.qlik.com/t5/QlikView/Comparing/m-p/306030#M1200709 <HTML><HEAD></HEAD><BODY><P>Thank you so much! <IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P></BODY></HTML> Mon, 14 Feb 2011 17:53:37 GMT https://community.qlik.com/t5/QlikView/Comparing/m-p/306030#M1200709 qw_johan 2011-02-14T17:53:37Z