How to consider the values of one cell in one row and do not consider different value in same row

[#1]

Hi,

I am trying to load an excel  which has data something like below

Chip#	A	B	C
AAA	Yes	Under evaluation	Not supported
BBB	Planning	Yes	Yes

I want to load this excel data into qlikview and consider the records as below condition

1)If A column has 'Yes' value i do not want that Chip#  but i want that Chip# for B since value under B is "Under evaluation".Similarly i want to work for all columns and not consider the chip# when value under under the columns is "Yes".

[settu_periasamy]

Hi,

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

[sunny_talwar]

Not sure I am completely clear about the logic? What's the expected output for Row 2? and may be add more rows where there could be more variation?