topic Re: sum max in pivot in QlikView

sum max in pivot

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

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.

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

Re: sum max in pivot

ecolomer — Thu, 10 Aug 2017 09:57:54 GMT

Can you explain more your request?

What is your expectative for the results in last column

Re: sum max in pivot

antoniotiman — Thu, 10 Aug 2017 10:16:13 GMT

Hi Jacek,

maybe this

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

Regards,

Antonio

Re: sum max in pivot

jordan231 — Thu, 10 Aug 2017 10:44:54 GMT

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

Re: sum max in pivot

vishsaggi — Fri, 18 Aug 2017 00:56:06 GMT

Hello Jacek,

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