Sum or aggr

[fabio182]

Hi, everyone

It´s possible:

VIN       DES

AA        20

AA        20

I want the sum is only one that is only 20, QlikTech Admin

Sum(DES) = 20

[Anonymous]

I'm not sure I understand the question...  Maybe

sum(distinct DES)

[fabio182]

Hi Michael,

VIN       DES

AA        20

AA        20

BB        20

In this case, exclude VIN tip BB

AA  20

BB  20

---------------

       40

[Anonymous · Accepted solution]

Can do that too:
sum(aggr(sum(distinct DES),VIN))

See attached

[fabio182]

Thanks Michael !!!