Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tiklam_dynasys
Contributor

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
MVP
MVP

Re: Qlik Sense Find what pattern exist most

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)

tiklam_dynasys
Contributor

Re: Qlik Sense Find what pattern exist most

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

MVP
MVP

Re: Qlik Sense Find what pattern exist most

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

Community Browser