Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense Find what pattern exist most

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

3 Replies
petter
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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