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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
paweln
Contributor III
Contributor III

Rank made for data from different columns

Dear All,

I have such table:

 

paweln_0-1597987217315.png

 

These numbers can appear in all 5 columns. I'd like to have another table with ranking of the most popular numbers within all 5 columns. (1st column - number, 2nd column - how often in appears). I prefer to have it in the chart.

3 Replies
thi_pham
Creator III
Creator III

How your expected output look like?

paweln
Contributor III
Contributor III
Author

Like this:

paweln_1-1597996438203.png

 

 

Steven_Haught
Creator III
Creator III

@paweln try this:

Count(TOTAL <Heat1> Heat1)