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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Some question about aggr() function

I have a question confusing me for a long time.

if I write a scripts like this:  min(Aggr(sum(Spend),User_Name,Package_name)), I can get the minimal  Total Spend of each User for each Package. But what if I want to get the name and the package name , How can I do that??

thanks for the warm help.

1 Reply
swuehl
MVP
MVP

Maybe like

=FirstSortedValue(DISTINCT

      Aggr(User_Name ,User_Name,Package_name),

          Aggr(sum(Spend),User_Name,Package_name)

)