Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

Hi,

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


Chip#
ABC
AAAYesUnder evaluationNot supported
BBBPlanningYesYes

  

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".

2 Replies
settu_periasamy
Not applicable

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

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 applicable

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

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?