2 Replies Latest reply: Nov 17, 2017 9:13 AM by Victor GREFFET RSS

    count duplicates in a column

    Victor GREFFET

      Hi community,

       

      Still stuck on the problem related here  :

      Remove duplicates

       

      I'm trying to count the number of duplications that i have in my database for one field, I mean after loading my DATA, adding a column like that :

       

      ReferenceDuplicationNumber
      Ref 14
      Ref 14
      Ref 14
      Ref 21
      Ref14
      Ref 31
      Ref 41
      Ref 51
      Ref 61
      ....

       

      Do you have an idea ?

       

      Thanks,

       

      Victor

        • Re: count duplicates in a column
          Chanty 4u

          In qlikview when you read the fields if there is same records it will show single value if it is not associated with any value or field. Also if you count the field you get its count result.

           

          like see the difference in the script results


          Count(Field)


          Or


          Count(Distinct Field)

            • Re: count duplicates in a column
              Victor GREFFET

              Thks for your reply,

               

              Load distinct Reference or load Reference is the same for me because this is not exactly the same line in duplication, the ref is the same but I can have additionnal values in other field.

              In the case below, load distinct Ref would give me 2 line. and I want to keep only the yellow line.

              Capture.PNG