Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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