topic Re: Display calc times of objects? in QlikView

Display calc times of objects?

scotthan — Wed, 22 Jan 2014 15:11:59 GMT

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?

Re: Display calc times of objects?

whiteline — Wed, 22 Jan 2014 19:30:33 GMT

Hi.

Yeah, you need a very fast man with a stopwatch

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

Re: Re: Display calc times of objects?

Anonymous — Wed, 22 Jan 2014 19:37:51 GMT

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

Re: Display calc times of objects?

brindlogcool — Wed, 22 Jan 2014 19:37:54 GMT

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

Re: Display calc times of objects?

Anonymous — Wed, 22 Jan 2014 19:44:09 GMT

Actually, it can be done by a macro:

sub ct

set Ch= ActiveDocument.GetSheetObject("CH01")

time = Ch.GetObjectCalcTime

msgbox(time)

end sub

Re: Display calc times of objects?

whiteline — Wed, 22 Jan 2014 19:51:09 GMT

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.