Calculate rate of sale(nested aggregation not allowed)

[saichawan]

Hi,

I need a urgent help on this. i need to find rate of sale, the number of units sold pe week for current and previous year. below is the formula i'm using.

 ='Current Year:'&Num( Sum({<[Trading Week End Date] = {'$(=Year(Today()))'}>} (RTL_QTY) /Count(date)),'##.00')&
' Last Year:'&Num(Sum({<[Trading Week End Date] = {'$(=Year(Today())-1)'}>} (RTL_QTY) /Count(date)),'##.00') 

can you please help with the solution.

[Brett_Bleess]

Sai, the best I have is the following Design Blog link, I am also leaving the base Design Blog URL below that in case you want to search further.  I did move your post to a new post as well, hopefully one of the Set Analysis gurus will be able to have a look and leave you something better:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[Brett_Bleess]

See duplicate post at: https://community.qlik.com/t5/New-to-QlikView/nested-aggregation-not-allowed/m-p/1649500#M383754

Regards,
Brett