Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Theo_Westseit
Contributor III

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

Labels (1)
1 Solution

Accepted Solutions
hic
Former Employee

Try

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

View solution in original post

2 Replies
hic
Former Employee

Try

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

Theo_Westseit
Contributor III
Author

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