Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
antoniotiman
Master III
Master III

Evaluation Time before executing object

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

4 Replies
jagan
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

Hi,

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

Regards,

Jagan.

tresesco
MVP
MVP

antoniotiman
Master III
Master III

Thanks Jagan,

but I alredy know time after executing object.

Regards