Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

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.

shubham_kumar
Contributor III

Want to compare string

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

1 Reply
MVP & Luminary
MVP & Luminary

Want to compare string

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.