Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
To improve performance avoid using Count(DISTINCT) instead arrive a flag and use Sum(Flag).
Regards,
Jagan.
Hi Jagan,
Henric says that it's a myth : http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/22/a-myth-about-countdistinct
Thanks Jagan,
but I alredy know time after executing object.
Regards