Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

1 Solution

Accepted Solutions
satishkurra
Specialist II
Specialist II

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

Also consider the valuable point from Sundeep

View solution in original post

3 Replies
sudeepkm
Specialist III
Specialist III

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.

satishkurra
Specialist II
Specialist II

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

Also consider the valuable point from Sundeep

Not applicable
Author

Thank you both, I appreciate the tips!