Month aggregation: Nested aggregation not allowed

[Theo_Westseit]

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,...)

[hic · Accepted solution]

Try

Sum({$<Month={'$(=Num(Month(Today()-35),'00'))'}>} SALES_40 )

[Theo_Westseit]

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