Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
Could you please translate the following expression:
=sum({<Date={'>=$(=MonthStart(PERI, -11))<=$(=Date(Max(PERI)))'}>} LOPP)
Thanks,
All this is saying is that Sum LOPP for the last 12 months.
Thanks
Where can I learn about set analysis?
It's difficult to understand the formulas and expressions on Set Analysis.
Would you recommend something?
Thought I had posted this to a prior post, but here it is again:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Regards,
Brett