topic Re: Expression as Script while loading the file! in QlikView

Expression as Script while loading the file!

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

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

Re: Expression as Script while loading the file!

brunolelli87 — Tue, 12 May 2020 14:24:14 GMT

Any help?

Re: Expression as Script while loading the file!

Brett_Bleess — Thu, 04 Jun 2020 17:02:43 GMT

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-practices-data-modeling.htm

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

Regards,
Brett

Re: Expression as Script while loading the file!

brunolelli87 — Thu, 04 Jun 2020 19:30:12 GMT

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