topic Re: Translate an expression in QlikView

Translate an expression

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

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

Re: Translate an expression

brunolelli87 — Tue, 12 May 2020 14:38:11 GMT

Any help guys???

Re: Translate an expression

Brett_Bleess — Thu, 04 Jun 2020 13:57:32 GMT

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/SetAnalysis/set-analysis-expressions.htm

About the best I can offer.

Regards,
Brett

Re: Translate an expression

brunolelli87 — Thu, 04 Jun 2020 19:59:22 GMT

Thanks, Brett!