2 Replies Latest reply: Apr 29, 2016 3:26 PM by Sunny Talwar RSS

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

    Rekha Harish

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