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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

nested aggregation not allowed

Hi,

I am getting the error "nested aggregation not allowed" for the following expression...

sum(if (FirstSortedValue(Date(TxnDate), TxnDate) = '1/2/2012', Amount, 0))

Can you guys please help me understand the reasons?

10 Replies
Not applicable
Author

I do not have access to the scripts.