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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Tibz
Contributor II
Contributor II

Match with a field

Hello !

All i want to do is to check if there is a value called 'B' in a FIELD2 at the row 'A' in FIELD1

I've tried:

=if(match('A' , { $ <FIELD1= {'B'}>} FIELD2 ),1,0)

=if(match('A' , FIELD1 ),1,0)

don't works either

I've also tried

=if(FieldValue('FIELD1 ',fieldIndex('FIELD2 ', 'A'))='B',1,0)

But it doesnt works because there is a lot of duplicate values in FIELD1

 

Thanks in advance for your answering,

Regards

Labels (2)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

Perhaps this?

If(FIELD1='A', If(FIELD2='B', 1,0))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

Perhaps this?

If(FIELD1='A', If(FIELD2='B', 1,0))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Tibz
Contributor II
Contributor II
Author

thanks a lot !