Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,...)
Try
Sum({$<Month={'$(=Num(Month(Today()-35),'00'))'}>} SALES_40 )
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