Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
satyam285889
Contributor II
Contributor II

Please Help with Set Analysis Expression

I'm trying to make a new column using the set expression for Highest Category sold by each employee to show up.

 

This is what I have so far on the table.

 

satyam285889_0-1634186705087.png

 

2 Replies
tresesco
MVP
MVP

Since you haven't shared a sample data set, I will assume and suggest accordingly. Try something like:

FirstSortedValue(Category ,-Aggr(Sum(Sales), Category, EmployeeID))

satyam285889
Contributor II
Contributor II
Author

I've shared a copy of the screenshot from my Table.

I'm trying to get the highest selling Category for each employee that is listed in the table. Using the Set Analysis expression.