Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple match condition

I have the following dimension set up to only show Res Id with the following values but I also need to extract the data if the

GP ID is equal to CTL01

Is there a way for me to do a match if either one exists????

=if(Match([Res ID],'100529','400068','104198','609022'),'ABC Supply')

1 Solution

Accepted Solutions
erikzions
Creator
Creator

=if(Match([Res ID],'100529','400068','104198','609022') or [GP ID] = 'CTL01','ABC Supply')


This might do what you need.

View solution in original post

4 Replies
erikzions
Creator
Creator

=if(Match([Res ID],'100529','400068','104198','609022') or [GP ID] = 'CTL01','ABC Supply')


This might do what you need.

maxgro
MVP
MVP

you can add and or condition to your if as needed

if( (match(....) or match(.....)) and (match(.....) or match(.....)), ...) as ....

Not applicable
Author

if I need to add another layer such as

an and ID = 39 or id not equal 39

in other words (if the res id = '100529', etc, or gp id = CTL01 ) and id = 39

would this be possible?????

its_anandrjs

You can simply use

=if(Match ( [Res ID], 100529,400068,104198,609022),'ABC Supply') or Match( [GP ID] = 'CTL01','ABC Supply')

   And ID = 39