Translate an expression

[brunolelli87]

Hello guys,

I have just started working with QlikView, and I created the following expression in order to sum the values of [Patrimônio Líquido]*1000/NumeroDeAções belonging to each quarter...

=if(aggr(NODISTINCT sum([Patrimônio Líquido]*1000/NumeroDeAções),Quarter)='0',
aggr(RangeSum(above(sum({<Month=, Date={'>=$(=MonthStart(Periodo, -1))<=$(=Date(Max(Periodo)))'}>} [Patrimônio Líquido]*1000/NumeroDeAções),0,100)),Periodo),
aggr(NODISTINCT sum([Patrimônio Líquido]*1000/NumeroDeAções), Quarter))

It's working, but to tell you the truth I have no idea of what I did. 
I don't even know how it's working.

Could you please translate the following formula so I can learn and understand what's going on?

Thanks
Bruno Lelli

[brunolelli87]

Any help guys???

[Brett_Bleess · Accepted solution]

Have a look at the following Design Blog posts:

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

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulative-Sums/ba-p/1468010

If you need others, please use the following link to search for further posts related to those items, and you can also review the Help too, as it is pretty detailed.

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

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

About the best I can offer.

Regards,
Brett

[brunolelli87]

Thanks, Brett!