10 Replies Latest reply: Jul 27, 2017 3:41 PM by Amuktha Chakilam RSS

    Finding duplicates in a column(QlikSense)

    Amuktha Chakilam

      I have  a data table containing columns id, date, phone and the column flag which i want to modify (1 for unique and 0 for duplicate)

       

      I want to find duplicates in phone column and mark flag based on date. Eg: If the same phone number appears thrice in the column then the earliest record (based on date) should be marked as 1 and remaining two records(duplicates) should be marked as 0.

       

      Expected Output : date format : dd/mm/yyyy

      qlik.PNG

       

      thank you.