Discussion board where members can get started with Qlik Sense.
I got a table with below data, i would like to find out what pattern exist most:
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.
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)
Thanks for reply,
Mode() will only return one value.
But i would like to get at least two number exist most in each ID.
Then you can use a set expression to exclude the most used value when you are going to get the second most used value....