Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
fabio182
Contributor II

Sum or aggr

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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Re: Sum or aggr

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

See attached

4 Replies
mov
Esteemed Contributor III

Re: Sum or aggr

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

sum(distinct DES)

fabio182
Contributor II

Re: Sum or aggr

Hi Michael,

VIN       DES

AA        20

AA        20

BB        20

In this case, exclude VIN tip BB

AA  20

BB  20

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

       40

mov
Esteemed Contributor III

Re: Re: Sum or aggr

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

See attached

fabio182
Contributor II

Re: Sum or aggr

Thanks Michael !!!