Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Compare two fields

I would like to compare two fields within a table.

example:

Bring field only when X equals Y

Tags (3)
1 Solution

Accepted Solutions
ryanhicks
New Contributor III

Re: Compare two fields

That is doable.

if(Fieldx =FieldY, Field C) as Field C

this will only load Field C if X =Y. 

If they don't equal, the value will be null.

3 Replies
ryanhicks
New Contributor III

Re: Compare two fields

That is doable.

if(Fieldx =FieldY, Field C) as Field C

this will only load Field C if X =Y. 

If they don't equal, the value will be null.

gajapathy74
Contributor II

Re: Compare two fields

hi,

BirthAddress:

LOAD

          BirthAddress

Resident

          UserAddress

Where BirthAddress=PresentAddress;

not sure is this your requirement.

Not applicable

Re: Compare two fields

Thanks, it really worked

Community Browser