Evaluation Time before executing object

[antoniotiman]

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]

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]

Hi,

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

Regards,

Jagan.

[tresesco]

Hi Jagan,

Henric says that it's a myth : http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/22/a-myth-about-countdistinct

[antoniotiman]

Thanks Jagan,

but I alredy know time after executing object.

Regards