String equality comparison

[#1]

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

[#2 · Accepted solution]

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

[#3]

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!!

[#4]

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