Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Jojo17
Contributor
Contributor

Sorting Top 10 Movies by Gender (based on average rating)

Hi I have been having some issues with sorting my Pivot Table. 

My question I want to answer is - who are the top 10 movies for females and males. 

I have already set a sort by Gender, so I would like to have the average rating sorted in order and highlighting only the top 10. I have tried to set it various times and ways on the sort tab, but cannot seem to solve it. 

Capture.PNG

Capture.PNG

Capture.PNG

Labels (1)
1 Reply
uacg0009
Partner
Partner

Hi Jodi,

Actually in my mind, if the pivot table has 2 or more expressions, the sort function will be dead. I don't know whether it's a bug or not.

But I recommend that if possible, you can use the straight table.

And if you only want to show the top 10 in the pivot table, you can also write a calculated dimension, then only show the top 10 movies.

Thanks.

Aiolos