topic Want to compare string in QlikView

Want to compare string

Anonymous — Thu, 08 Dec 2011 07:05:37 GMT

Hi,

I want to compare a string where if some field " ABC=' 25' " its not working where as if i put the same condition in opposite way i;e " ABC<> '25' thats work!! I am unable to understand. Could anyone tell me the reason or solution for it ?

Thanking you in advance

Best,

Shubham Kumar

Want to compare string

jagan — Fri, 09 Dec 2011 12:31:58 GMT

Hi,

How many values are there in the field, if there is only one value it works as expected, if there are multiple values then ABC='25' returns false, because while comparing a field with a given value(25), the field has multiple values so it returns false.

Regards,

Jagan.