Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
Then you can use a set expression to exclude the most used value when you are going to get the second most used value....