topic Re: Multiple match condition in QlikView

Multiple match condition

Mon, 02 Jun 2014 15:57:46 GMT

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')

erikzions — Mon, 02 Jun 2014 16:01:22 GMT

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

This might do what you need.

maxgro — Mon, 02 Jun 2014 16:07:40 GMT

you can add and or condition to your if as needed

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

Mon, 02 Jun 2014 18:00:55 GMT

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 — Mon, 02 Jun 2014 18:09:27 GMT

You can simply use

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

And ID = 39