Return the number with the highest probability to occur

[#1]

Hi,

This is when i wished i would have pay more attenntion at statistics class at school...

Say I have the following table:

Amt
3
6
3
3.2
5
3
6
3
2
1.7

I would like to get the number with the highest probability to occur (In this case 3 = 4 occurences)

Is there a function in qlikview that can do that ? In the script?

Thanks,

Dror

[tresesco · Accepted solution]

Mode() ?

[#3]

That's was quick! Thanks!