Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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".
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'));
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?