Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangyubo18
New Contributor II

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
MVP
MVP

Re: Some question about aggr() function

Maybe like

=FirstSortedValue(DISTINCT

      Aggr(User_Name ,User_Name,Package_name),

          Aggr(sum(Spend),User_Name,Package_name)

)

Community Browser