Display calc times of objects?

[scotthan]

When you execute a search in Google it will tell you how long the search took to execute, we would like to provide the same information inside a QlikView dashboard based on how long it takes to apply a filter. So, as a user selects a Region in a QV Dashboard, I want to know how long it took QlikView to actually apply the filter. Is that possible?

[whiteline]

Hi.

Yeah, you need a very fast man with a stopwatch  

The camera with a slow motion capture feature is also suitable.

[Anonymous]

Scott

In QV Desktop :

• Settings
• Document Properties

This shows various metrics for each object including Calc Time.

The Help says about this :

CalcTime The time in milliseconds needed for the last recalculation of the object's contents. This information is only relevant for objects that are actually calculated (charts, Table boxes and any objects containing formulas). 

Would this be of use to you ?

Best Regards,     Bill

[brindlogcool]

Sheet properties- Objects will give you the calc time for the current selection.

[Anonymous · Accepted solution]

Actually, it can be done by a macro:

sub ct

set Ch= ActiveDocument.GetSheetObject("CH01")

time = Ch.GetObjectCalcTime

msgbox(time)

end sub

[whiteline]

Hi Bill.

I also thought about that.

Unfortunately the CalcTime is useless when you have more than one chart because of multitasking.

You see the times but you don't know when one object starts and the other ends and how many of them is calculated simultaneously.

In addition QV caches the results, so you have to restart it to make measures otherwise you'll see zeros.