Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find maximum frequent number

load * Inline
[Numbers
20
25
35
35
35
44
11
11
55
55
]
;

I have used =max(aggr((count(Numbers)),Numbers))

In text box I want 35 instead of 3. Because number 35 has
repeated 3 times.

Any Idea?

Regards

Vinay


Labels (1)
11 Replies
MK_QSL
MVP
MVP

Thanks Rob... ! You are a champion.!

MK_QSL
MVP
MVP

One question, using my solution how can we get the same result with ignoring user's selection of Numbers !

Thanks in advance for your precious time !