topic Re: Max Year within AGGR Expression in QlikView

Max Year within AGGR Expression

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

Below is not working and is showing the 'Expression OK' message, however there is a error underscore between the end of the set analysis } and ,

=Sum(Aggr(Avg({<YEARCALC=$(=Max(YEARCALC))>},[Number attended]),EventID,PREVINSTNAME))

I'm presuming there is an error with the syntax but not sure how to fix.

Thanks in advance

Anil_Babu_Samineni — Wed, 21 Mar 2018 13:14:33 GMT

May be this?

=Sum(Aggr(Avg({<YEARCALC={"$(=Max(YEARCALC)"}>} [Number attended]),EventID,PREVINSTNAME))

aliyoung92 — Wed, 21 Mar 2018 13:19:28 GMT

Thank you