Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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