Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the follow problem, Qlik detects the same value in one columns as different values. I already check and im sure that the values are the same from de origin. Also if i download the data to excel and excel recognise the values as one.
Check if there is a line break special char at the end, I faced it similar issue when someone manually added value in SQL using edit feature and pressed enter in the cell. When Qlik reloaded that value it had line break and wasn't matching as expected
Try wrapping a trim() around the field, like this:
Trim([Field name])
I will remove blanks in the beginning or the end of the field value.