What is your expected output? if you provide more samples, would help us to give the suggestion.
may be try with where condition when you load from excel to qlikview. something Like
Load Chip# From Source
where (not Match(A,'Yes') or Match(B,'Under evaluation')) and
(Match(A,'Under evaluation') or not Match(B,'Yes'));