topic Re: Aggr Expression in QlikView

Aggr Expression

sona_sa — Wed, 11 Aug 2021 07:15:47 GMT

Hi,

What is wrong in this expression :

=Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode)

I want sum of salary of EMPCODE, Who has joined in End of That Month DOJ wise.

Thanks.

Re: Aggr Expression

lironbaram — Wed, 11 Aug 2021 08:31:18 GMT

the expression above returns a virtual table
of empcode and the expression value
If you want to get the total number you need to wrap it by another sum function

Re: Aggr Expression

MayilVahanan — Wed, 11 Aug 2021 08:49:30 GMT

Hi Sona,

Try like below

=Sum(Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode))

Re: Aggr Expression

sona_sa — Wed, 11 Aug 2021 09:37:17 GMT

Thanks. Working.

Can we convert the same to Set Analysis.

=Sum(Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode))

Thanks.

Re: Aggr Expression

Kushal_Chawda — Wed, 11 Aug 2021 10:58:38 GMT

@sona_sa may be below

Sum({<EmpCode ={" =MonthEnd(Link_Date)=Monthend(DOJ)"}>}YearlyValue)