7 Replies Latest reply: Apr 22, 2015 3:58 AM by Lance Chong RSS

    Remove field rows on conditions

      Hi,

       

      I have a simple question. I have an Excel file which I loaded into Qlikview. I want to remove entire rows if a field contains certain characters. More specifically, I have a field named Counterparty. I want to remove the entire row if the field Counterparty contains a name that begins with INT or EXT.

       

      Thanks!