topic Translate a simple set analysis expression in QlikView

Translate a simple set analysis expression

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Dears,

Could you please translate the following expression:

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

Thanks,

sunny_talwar — Wed, 13 May 2020 16:00:25 GMT

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

brunolelli87 — Wed, 13 May 2020 16:44:27 GMT

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 — Wed, 10 Jun 2020 13:33:29 GMT

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

Regards,
Brett