Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
New 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

1 Solution

Accepted Solutions
Highlighted

Re: Match with a field

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Highlighted

Re: Match with a field

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
New Contributor II

Re: Match with a field

thanks a lot !