topic String equality comparison in QlikView

String equality comparison

Wed, 23 Feb 2011 06:59:45 GMT

Hello,

I am using the relation operator '<>' in the following load statement to filter out the records:

LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID <> 'rozanne' and LOGIN_ID <> 'patric');

This is not including these two login ids into the result.

When I using the relation operator '=' to include these login ids into the records , it is not working.

LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID = 'rozanne' and LOGIN_ID = 'patric');

How to do the string equality checking in QlikView 9 in above scenario?

Thanks in advance.

Samir

String equality comparison

Wed, 23 Feb 2011 07:10:59 GMT

Hi Samir,

What you are trying is correct expression.

LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID = 'rozanne' and LOGIN_ID = 'patric');

But when ur taking '<>' condition, use 'and' keyword between two conditions.

when ur taking '=' condition, use 'or' keyword between two conditions.

Regards,

Yogesh

String equality comparison

Wed, 23 Feb 2011 07:14:08 GMT

depends on the requirement just Yogesh explained above. weather you want to filter out records with those two values or have only records with those values. Cheers!!

String equality comparison

Wed, 23 Feb 2011 07:20:33 GMT

Thanks Yogesh for your valuable reply. It worked for me.