3 Replies Latest reply: Jun 15, 2018 3:27 AM by Petter Skjolden RSS

    Qlik Sense Find what pattern exist most

    Louis Lam

      Hi All,

       

      I got a table with below data, i would like to find out what pattern exist most:

      IDResult 1Result 2Result 3Result 4Result 5Result 6Result 7
      137822294633
      21112263334411
      322293738404149
      48192324354529

       

      From above data, 22 and 29 exist twice.

      How can we find out the pattern by using Qlik Sense.

      It can be 2 number or more.

       

      Best Regards,

      Louis