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: 
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
Champion III
Champion III

Maybe like

=FirstSortedValue(DISTINCT

      Aggr(User_Name ,User_Name,Package_name),

          Aggr(sum(Spend),User_Name,Package_name)

)