topic Re: Error in expression: Nested aggregation not allowed in QlikView

Error in expression: Nested aggregation not allowed

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

Good morning, I'd been trying to make this expression work:

SUM( {< [ACCOUNT_TYPE]={'Change Request'} >} ([WORKLOG.TIMEWORKED]/$(vFTE)))

where vFTE its

Count( {< WorkingDay={'Work'} >} WorkingDay)*8*$(vMODFTE)

Why the expression gives me back this error and doesnt show the result?

Re: Error in expression: Nested aggregation not allowed

vishsaggi — Wed, 28 Sep 2016 16:09:02 GMT

Can you send a sample app or all the variable expressions used. Did you use text objects and tried displaying those variables are they giving any values in the textobject ?

Try this?

= SUM( {< [ACCOUNT_TYPE]={'Change Request'} >} [WORKLOG.TIMEWORKED]) / $(vFTE)

Re: Error in expression: Nested aggregation not allowed

Clever_Anjos — Wed, 28 Sep 2016 16:20:17 GMT

You can´t use an aggregation inside other aggregation without using AGGR()

Your expression is SUM(([WORKLOG.TIMEWORKED] / count(WorkingDay))

Re: Error in expression: Nested aggregation not allowed

maxgro — Wed, 28 Sep 2016 16:21:10 GMT

maybe

SUM( {< [ACCOUNT_TYPE]={'Change Request'} >} [WORKLOG.TIMEWORKED] )

($(vFTE))

regarding the error you can read here

Aggregations and Function Classes