topic Exclude Column in nested statement in QlikView

Exclude Column in nested statement

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

Hi All,

The below expression should ignore the field organization. I am trying to ignore the field organization, but i am getting this error.

Error: Error in expression:

Nested aggregation not allowed

= avg( aggr (Avg( if( Year_Flag >0 ,

Aggr(FirstSortedValue({<Year={'>=$(=max(Year)-2)<=$(=max(.Year))'}>}Value, -Date),

Year_Org))),Value))

Thanks in advance

sunny_talwar — Fri, 17 Aug 2018 16:21:48 GMT

Where in your expression you think you are ignoring the field organization?

Gysbert_Wassenaar — Fri, 17 Aug 2018 16:25:02 GMT

Perhaps like this:

= avg({<organization=>}

aggr(

Avg({<organization=>}

if(Only({<organization=>}Year_Flag) >0

,Aggr(

FirstSortedValue({<organization=,Year={'>=$(=max({<organization=>}Year)-2)<=$(=max({<organization=>} Year))'}>}Value, -Date)

,Year_Org

)

Value)

)