Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

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

Contributor II
Contributor II

Re: Match with a field

thanks a lot !