Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare two fields

I would like to compare two fields within a table.

example:

Bring field only when X equals Y

1 Solution

Accepted Solutions
ryanhicks
Contributor III
Contributor III

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.

View solution in original post

3 Replies
ryanhicks
Contributor III
Contributor III

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
Creator II
Creator II

hi,

BirthAddress:

LOAD

          BirthAddress

Resident

          UserAddress

Where BirthAddress=PresentAddress;

not sure is this your requirement.

Not applicable
Author

Thanks, it really worked