topic Re: Sum Distinct in QlikView

Sum Distinct

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

Dear all,

I have the attached data and would appreciate some help calculating the sum of the abs_pos_vol by distinct our_reference.

The values are slightly different, however I am happy to sum either the lower or higher value.

Thanks,
Daniel

Re: Sum Distinct

sunny_talwar — Tue, 25 Feb 2020 14:10:18 GMT

May be this for max

Sum(Aggr( Max(Aggr( abs_pos_vol , our_reference)) , our_reference))

or this for Min

Sum(Aggr( Min(Aggr( abs_pos_vol , our_reference)) , our_reference))

Re: Sum Distinct

danielnevitt — Tue, 25 Feb 2020 14:19:57 GMT

Hi Sunny,

Thanks for the quick reply.

Unfortunately that doesn't work though. The expression just returns a blank value.

Regards,
Daniel

Re: Sum Distinct

sunny_talwar — Tue, 25 Feb 2020 14:53:58 GMT

What is abs_pos_vol? a field or expression?

Re: Sum Distinct

danielnevitt — Tue, 25 Feb 2020 15:16:19 GMT

abs_pos_vol is a numeric field.

Regards
Daniel

Re: Sum Distinct

sunny_talwar — Tue, 25 Feb 2020 15:52:45 GMT

Sum(Aggr( Min(Aggr( abs_pos_vol , our_reference, abs_pos_vol)) , our_reference))

Re: Sum Distinct

Brett_Bleess — Thu, 26 Mar 2020 15:22:27 GMT

Daniel, did Sunny's last post get you what you needed? If so, please do not forget to close out your thread by using the Accept as Solution button on that post of Sunny's to do so. This also gives him credit for the assistance and will let other Members know it worked. If you did something different, you can post what you did and then mark that, but please be sure to close this out if possible.

Regards,
Brett