Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
praveenvinnakota
Contributor
Contributor

Expressions Analyser

 
 

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.

3 Replies
edwin
Master II
Master II

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

marcus_sommer

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

Brett_Bleess
Former Employee
Former Employee

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_Proper...

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-p...

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.