Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
See duplicate post at: https://community.qlik.com/t5/New-to-QlikView/nested-aggregation-not-allowed/m-p/1649500#M383754
Regards,
Brett