Error: Nested Aggregation not allowed

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

Hello guys,

I'm using the following expression on a table chart to collect the Growth Rate, and it's working perfectly:

=rate(3,0,-Avg({<Flag = {'3 Year Ago'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1),Avg({<Flag = {'Current'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1))

My Table chart has the following dimension:

=if(Date(AsOfDVPG)>today(),'',Date(AsOfDVPG))

I'm trying to show the last available Growth Rate, when the user select a specific field. For that I'm trying to use the following expression:

= FirstSortedValue( rate(3,0,-Avg({<Flag = {'3 Year Ago'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1),Avg({<Flag = {'Current'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1)) -DVPG, 1)

But I'm getting an error: "Error: Error in Expression: Nested aggregation not allowed"

How can I do that?

How can I show the last available Growth Rate on a FieldBox?
In this example, I'm expecting to see the 1.25%.

Thanks

Re: Error: Nested Aggregation not allowed

brunolelli87 — Sat, 30 May 2020 21:12:19 GMT

Hello folks,

Do you guys have any idea about how can I solve it?

Thanks

Re: Error: Nested Aggregation not allowed

brunolelli87 — Sun, 31 May 2020 11:49:38 GMT

Any idea guys?

topic Re: Error: Nested Aggregation not allowed in QlikView

Error: Nested Aggregation not allowed

Re: Error: Nested Aggregation not allowed

Re: Error: Nested Aggregation not allowed