Qlik Community

QlikView Documents

Documents for QlikView related information.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

How to get the most frequent event?

New Contributor

How to get the most frequent event?

I have a table with a column named event. In the column there is a set of data A,B,A,C,A.
How can I get the most frequent event happened by using aggregation count and max?

Labels (1)
New Contributor

 The output should be the event which is A, not the frequency of the event happened. 
Really appreciate if anyone can help. 


Version history
Revision #:
1 of 1
Last update:
‎12-04-2018 03:55 AM
Updated by: