topic Re: Evaluation Time before executing object in QlikView

Evaluation Time before executing object

antoniotiman — Tue, 22 Apr 2014 07:15:15 GMT

Hi,

haw can I evaluate approximately run-time of object/expression before executing ?

I would use this for set "conditions of object/expression" to avoid time too long.

I think to a function like "Explain" of SQL DB.

Currently I use :

conditions Count(DISTINCT DimensionA)*Count (DISTINCT DimB)*Count(DISTINCT DimC) < $(vLimitObj1)

Any suggestion ?

Regards

jagan — Wed, 23 Apr 2014 09:35:45 GMT

Hi,

You can get the calculation time like this

Sheet Properties-> Objects-> Object ID and check the CalcTime

It is the time taken to load the object, but it is not possible to get through any function.

Regards,

Jagan.

jagan — Wed, 23 Apr 2014 09:37:26 GMT

Hi,

To improve performance avoid using Count(DISTINCT) instead arrive a flag and use Sum(Flag).

Regards,

Jagan.

tresB — Wed, 23 Apr 2014 09:43:39 GMT

Hi Jagan,

antoniotiman — Wed, 23 Apr 2014 10:09:59 GMT

Thanks Jagan,

but I alredy know time after executing object.

Regards