Qlik Community

Tutorials and How-To's

Documents explaining how to use Qlik Community and its features.

How to get the most frequent event?

akramhakim621
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)
Attachments
Comments
akramhakim621
New Contributor

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

Thanks.

Version history
Revision #:
1 of 1
Last update:
2 weeks ago
Updated by: