Discussion Board for collaboration on QlikView Scripting.
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')
Go to Solution.
=if(Match([Res ID],'100529','400068','104198','609022') or [GP ID] = 'CTL01','ABC Supply')
This might do what you need.
you can add and or condition to your if as needed
if( (match(....) or match(.....)) and (match(.....) or match(.....)), ...) as ....
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?????
You can simply use
=if(Match ( [Res ID], 100529,400068,104198,609022),'ABC Supply') or Match( [GP ID] = 'CTL01','ABC Supply')
And ID = 39