5 Replies Latest reply: Dec 8, 2014 10:06 PM by Gokul krishnaa CB RSS

    Reverse Duplicates

      How do we remove reverse duplicates in Qlikview?

       

      I have a table that contains rows like AB,AC,AD and BA,BC,BD. I want to retain only the first three rows? How to do this in Qlikview using self join?

      COL 1COL2
      AB
      AC
      AD
      BA
      CA
      DA