Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Error: Nested Aggregation not allowed

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"

Nested.png

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

2 Replies
brunolelli87
Creator II
Creator II
Author

Hello folks,

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

 

Thanks

brunolelli87
Creator II
Creator II
Author

Any idea guys?