Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sindus123
Contributor III
Contributor III

Exclude Column in nested statement

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

2 Replies
sunny_talwar

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

Gysbert_Wassenaar

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)

)


talk is cheap, supply exceeds demand