Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Translate a simple set analysis expression

Dears,

Could you please translate the following expression:

=sum({<Date={'>=$(=MonthStart(PERI, -11))<=$(=Date(Max(PERI)))'}>} LOPP)

 

Thanks, 

3 Replies
sunny_talwar

All this is saying is that Sum LOPP for the last 12 months.

brunolelli87
Creator II
Creator II
Author

Thanks

 

Where can I learn about set analysis?

It's difficult to understand the formulas and expressions on Set Analysis.

 

Would you recommend something?

Brett_Bleess
Support (Former)
Support (Former)

Thought I had posted this to a prior post, but here it is again:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.