Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jordan231
Contributor
Contributor

sum max in pivot

Dear Friends,

I'm struggle with my pivot table. Problem is like that. I have a detailed table with group , item and qty.

All i need to do is to get a max value but from a sum. I cannot find a proper way. sample.JPG

As you can see i tried to use function AGGR(NODISTINCT Max(Forecast),Group) , but when i do thet i got a maximum value but from a details table and i need to know what is the maximum sum. In  case below i need to get

for group A records 1 and 2 = 90 as a result of Item 1

for group B records 3 and 4 = 500 as a resulit  of item 4

4 Replies
ecolomer
Master II
Master II

Can you explain more your request?

What is your expectative for the results in last column

antoniotiman
Master III
Master III

Hi Jacek,

maybe this

Max(TOTAL <Group> Aggr(Sum(Forecast),Group,Item))

Regards,

Antonio

jordan231
Contributor
Contributor
Author

Antonio ! This is what i was looking for.
Thank you very much !

vishsaggi
Champion III
Champion III

Hello Jacek,

Can you close the thread if you got the answer marking Antonio's response.