
Contributor III
2022-01-24
03:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Month aggregation: Nested aggregation not allowed
Hello Guys,
i want to make an set analysis to display all Sales.
The month comes from today minus 35 days = december...
But qlik says, nested aggregation is not allowed:
Sum({$<Month={'$(=num(Month(Date(Today()-35,'YYYY-DD-MM'))))'}>}(Sum(SALES_40)/100))
Whats wrong? Thanks for your help!
FYI: The field "Month" contains Numbers (01,02,03,...)
994 Views
1 Solution
Accepted Solutions

.png)
Former Employee
2022-01-24
08:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 Replies

.png)
Former Employee
2022-01-24
08:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Sum({$<Month={'$(=Num(Month(Today()-35),'00'))'}>} SALES_40 )

Contributor III
2022-01-24
08:43 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you !!
I have an additional question to this set analysis, which can be found below:
https://community.qlik.com/t5/New-to-Qlik-Sense/Use-set-analysis-in-Dimension/m-p/1884558#M198945
749 Views
