topic Re: Alternative for Aggr() in QlikView

Alternative for Aggr()

beck_bakytbek — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

i have got a question, i use this expression on the User Interface:

Max(Aggr(Sum([Order Total]),[Customer Name], [Employee ID]))

and it does work well,

I want just know, how can i convert this expression within Script-area? And what kind of function can i use in Script-area instead of Aggr()

Thanks a lot in advance

beck

sunny_talwar — Wed, 15 Mar 2017 08:30:24 GMT

Lets say you have a table called Fact with the three fields [Order Total], [Customer Name], [Employee ID]

Fact:

LOAD [Order Total],
[Customer Name],

[Employee ID],

....

FROM ....;

Now you can do this

Aggr:

LOAD [Customer Name],

[Employee ID],

Sum([Order Total]) as [Sum Order Total]

Resident Fact

Group By [Customer Name], [Employee ID];

Do you want to find the max also? If you do... you can just do this

Max:

LOAD Max([Sum Order Total]) as [Max Sum Order Total]

Resident Aggr;

beck_bakytbek — Wed, 15 Mar 2017 08:34:10 GMT

Sunny thanks a lot for your quick response