topic Re: Variable by dimension in Aggr in QlikView

Variable by dimension in Aggr

Ajaj — Wed, 27 Oct 2021 13:23:48 GMT

I have the following data and expression :

test:
LOAD *
inline
[year,code,X
2020,'A',10
2021,'A',7
2019,'C',25
2020,'C',50
];

sum(
Aggr(
sum({<year={$(=max(year))}>}
X
)
,code
)
)

I want the sum of X for the max year grouped by code.

For example here I want 7 + 50 = 57.

Unfortunately my expression gives me 7

How can I tell the variable $ to take the aggr group into account ?

Thanks you,

maxgro — Wed, 27 Oct 2021 13:37:31 GMT

try with

sum(aggr(if(max(TOTAL <code> year)=year, sum(X)), code, year))

Ajaj — Wed, 27 Oct 2021 14:04:01 GMT

Nice, it works perfectly,

Thanks