Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Multiple match condition

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


This might do what you need.

4 Replies
erikzions
Not applicable

Re: Multiple match condition

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


This might do what you need.

maxgro
Not applicable

Re: Multiple match condition

you can add and or condition to your if as needed

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

Not applicable

Re: Multiple match condition

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
Not applicable

Re: Multiple match condition

You can simply use

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

   And ID = 39