Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Contributor II

unexpected mismatch

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

1 Reply
Not applicable

Re: unexpected mismatch


by using the text() function in load

then it differenciate the values


u want like number format

then use the num#() in the expression

it converts it into number

Community Browser