topic unexpected mismatch in QlikView https://community.qlik.com/t5/QlikView/unexpected-mismatch/m-p/438836#M1162020 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I've the following orderID:</P><P></P><P>0015&nbsp; and&nbsp; 000015 and they related customers. In my db, they represent two different orders, but into my qlikview document, I noted a strange behaviour.</P><P>In some pivot I have the first order (0015) with two customer inside, while in some list box, it's listed the second one only (000015).</P><P></P><P>It seems Qlik doesn't recognize the difference.</P><P>How can I manage this issue ? It's a bit strange for me.</P><P></P><P>Help please</P><P>Thanks in advance</P></BODY></HTML> Fri, 16 Nov 2012 00:43:51 GMT Anonymous 2012-11-16T00:43:51Z unexpected mismatch https://community.qlik.com/t5/QlikView/unexpected-mismatch/m-p/438836#M1162020 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I've the following orderID:</P><P></P><P>0015&nbsp; and&nbsp; 000015 and they related customers. In my db, they represent two different orders, but into my qlikview document, I noted a strange behaviour.</P><P>In some pivot I have the first order (0015) with two customer inside, while in some list box, it's listed the second one only (000015).</P><P></P><P>It seems Qlik doesn't recognize the difference.</P><P>How can I manage this issue ? It's a bit strange for me.</P><P></P><P>Help please</P><P>Thanks in advance</P></BODY></HTML> Fri, 16 Nov 2012 00:43:51 GMT https://community.qlik.com/t5/QlikView/unexpected-mismatch/m-p/438836#M1162020 Anonymous 2012-11-16T00:43:51Z Re: unexpected mismatch https://community.qlik.com/t5/QlikView/unexpected-mismatch/m-p/438837#M1162021 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>by using the <STRONG>text()</STRONG> function in load</P><P>then it differenciate the values</P><P></P><P>or</P><P> u want like number format</P><P>then use the <STRONG>num#()</STRONG> in the expression</P><P>it converts it into number</P></BODY></HTML> Fri, 16 Nov 2012 07:13:53 GMT https://community.qlik.com/t5/QlikView/unexpected-mismatch/m-p/438837#M1162021 2012-11-16T07:13:53Z