topic Re: Expressions Analyser in QlikView

Expressions Analyser

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

Hi,

I am new to qlikview. Is there a way to see the calc time for expressions? or any utility or tool to check the performance of the expressions which are in qvw file?

I tried Document Analyser, for objects I see the calctime but not for expressions 😞

Thanks,

Praveen.

Re: Expressions Analyser

edwin — Tue, 29 Sep 2020 16:33:11 GMT

that sounds like a great feature for the doc analyzer, you may want to pose that request to Rob

Re: Expressions Analyser

marcus_sommer — Wed, 30 Sep 2020 11:35:59 GMT

It's not so helpful as you think it would be because the heaviest part of the calculation is to create the object respectively the virtual tables behind it. This part is always single-threaded while the agregations would be performed in multi-threading.

In this regard it's important to build a suitable datamodel for your later views. Means to develop the datamodel in the direction of a star-scheme (by really huge datasets it should be even a single table) so that all relevant fields for an object comes from a single table. Within the UI (nested) if-loops, aggr-constructs and interrecord-functions should be as far as possible avoided.

If this basic-work is done you may pick those objects which are further too slow in their responses to investigate if they could be optimized in any way.

Beside this if I look on your screenshot it looked that the expression there is aimed to format results in k, m, b and so on. The added value of such a measure is often limited - therefore you should consider to skip it, especially if there are issues with the performance (probably the real reason for your question). Nevertheless if you want to remain by this logic you could improve the performance by changing the nested if-loop to pick() maybe in this way:

pick(len(floor(YourExpression)), '', '', '', 'k', 'k', 'k', 'm', ...)

- Marcus

Re: Expressions Analyser

Brett_Bleess — Wed, 21 Oct 2020 20:57:37 GMT

See the following Help doc link for the Calc time info I think you were trying to find:

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

It is going to be by object though. Here are a couple other links that may be of some help:

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