4 Replies Latest reply: Feb 28, 2018 10:37 PM by Chennaiah Nallani RSS

    Counting repeated rows

    Naomi Tan

      Hi. Say I have a table of data as below and I would like to count the number of rows that are duplicated (i.e. all 4 columns are the same).

      NameCol BCol CMonth-Yr
      JaneA1Jan-17
      JaneA1Jan-17
      JaneA1Jan-17
      JaneA1Jan-17
      JaneA1Jan-17
      PeteB2Jan-17
      PeteB2Jan-17
      PeteB1Jan-17
      KennyD1Feb-17
      LayllC2Feb-17
      LayllC2Feb-17
      MitchelleE4Feb-17
      KayD1Feb-17

       

      For the case above, number of repeated rows should be 6 ('Jane, A, 1, Jan-17' was duplicated 4 additional times; 'Pete, B, 2, Jan-17' duplicated once; 'Layll, C, 2, Feb-17' duplicated once, so total 6).

       

      Anyone can assist with the expression I should input on Qliksense?