topic Re: Calculation Condition vs. limiting by RANK/MAX - which is more resource intensive? in QlikView

Calculation Condition vs. limiting by RANK/MAX - which is more resource intensive?

Fri, 18 Sep 2015 14:07:50 GMT

I've been limiting the number of returned results in a table with two different approaches - either by using a calculation condition or using RANK/MAX in the expression. In terms of system resources and calculation time, which is worse? My assumption is that RANK/MAX would consume far more resources than a calculation condition, but I was wondering why that is. If my Calculation Condition is such that I require a certain minimum number of records before the expressions are run, isn't it just as taxing for the system to evaluate the entire dataset to make sure that condition is met?

Re: Calculation Condition vs. limiting by RANK/MAX - which is more resource intensive?

sudeepkm — Fri, 18 Sep 2015 14:12:07 GMT

you can check your chart's Calculation time and memory consumption from the Sheet Properties > Objects details.

you can consider taking a larger data set and then can check these stats.

Re: Calculation Condition vs. limiting by RANK/MAX - which is more resource intensive?

satishkurra — Fri, 18 Sep 2015 14:17:07 GMT

No doubt, Calculated dimensions are resource heavy and takes more time

Also consider the valuable point from Sundeep

Re: Calculation Condition vs. limiting by RANK/MAX - which is more resource intensive?

Fri, 18 Sep 2015 14:20:33 GMT

Thank you both, I appreciate the tips!