unexpected mismatch

[Anonymous]

Dear all,

I've the following orderID:

0015  and  000015 and they related customers. In my db, they represent two different orders, but into my qlikview document, I noted a strange behaviour.

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).

It seems Qlik doesn't recognize the difference.

How can I manage this issue ? It's a bit strange for me.

Help please

Thanks in advance

[#2]

Hi

by using the text() function in load

then it differenciate the values

or

u want like number format

then use the num#() in the expression

it converts it into number