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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
thundera1z
Contributor II
Contributor II

How to find the most occurring value in the particular year

Hello!

I'm trying to make a bar chart that could show me the most popular music genre in a particular year.

I have a dataset of 6000 songs (100 per year starting from 1960 up to 2019). My goal is just to show that in a particular year the most popular/most occurring music genre was "x".

Screenshot 2020-06-20 at 18.14.27.png

I know it has to do something with the MODE function. However, I'm struggling with finding a solution to the issue.

Any help would be appreciated.

Labels (2)
10 Replies
thundera1z
Contributor II
Contributor II
Author

@Taoufiq_Zarra 

Thank you man!

I think my issue is resolved now.