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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
sanpor1zd
Contributor II
Contributor II

Filter pane and set analysis table for top 5.

Hello,

I have a filter pane which consists of employee names, 
and also a table to show the top 5sales from the selected employee. 

i've tried using 
Sum({<Employee= {'=Rank(Sum(Sales)) <=5'}>}Sales)

but all i get was one column in my table.

Thank you. 

Edited (I have included a sample data)

10 Replies
tresB
Champion III
Champion III

PFA