Expression as Script while loading the file!

[brunolelli87]

Hello guys,

I would like to know what's the difference between an expression during the loading process, and an expression created at the chart's expression. Is there any difference between then? Do they use the same amount of memory?

I'm asking that because I have the following chart, with more than 10 calculated expressions, and I believe the performance could be better if the expressions were calculated during the loading process. Is that true?

And if it's true that I can optimize the dashboard by executing some expressions during the loading process, how could I convert the following expression to be loaded during the LOADING SCRIPT?

=sum(ValorAçãoFechamentoAjustado)/((aggr(RangeSum(above(sum({<Month=, Date={'>=$(=MonthStart(Periodo, -11))<=$(=Date(Max(Periodo)))'}>} [Lucro/Prejuízo do Período]),0,275)),Periodo)*1000)/NumeroDeAções)

Thanks,
Bruno

[brunolelli87]

Any help?

[Brett_Bleess]

Check out the following links, should put you on the right track:

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

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

Regards,
Brett

[brunolelli87]

Hello Brett, how are you?

As I've been mentioning on most of my posts, I've just started working with QlikView, and it's really an amazing tool. I'm focused on learning as much as possible during this "quarantine" - it's a personal goal, and yep, Brazil is still in "quarantine", with the political and financial crisis, but unfortunately, we are familiar with that! 😀

Thanks for all your attention, and assistance during my "Qlikview learning process", but I'm not sure how can I solve the main issue of my question with the links you sent me. Would you mind providing me some extra help?

Thanks again,
Best regards

Bruno