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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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.