Qlik Sense Find what pattern exist most

[Anonymous]

Hi All,

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

ID	Result 1	Result 2	Result 3	Result 4	Result 5	Result 6	Result 7
1	3	7	8	22	29	46	33
2	11	12	26	33	34	41	1
3	22	29	37	38	40	41	49
4	8	19	23	24	35	45	29

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

[petter]

If you organize the underlying data into one table like this:

ResultSet, ID, Result

1, 1, 3

1, 2, 11

1, 3, 22

1, 4, 8

2, 1, 7

2, 2, 12

2, 3, 29

....

You could simply use the Mode() function like this Mode(TOTAL Result)

[Anonymous]

Hi Petter,

Thanks for reply,

Mode() will only return one value.

But i would like to get at least two number exist most in each ID.

Best Regards,

Louis

[petter]

Then you can use a set expression to exclude the most used value when you are going to get the second most used value....