Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
can any body tell me how to avoid aggregate and increase the performance for regular faced scenarious.
regards
Mahesh T
All calculations are aggregations. See http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations
HIC
Hey Mahesh,
Can you post a sample file explaining where you wanna avoid using aggregation. Aggregation is one of the most useful tools and some calculations simply can't be done without aggregating.
Thanks
AJ
All calculations are aggregations. See http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations
HIC
Hi Henric,
i want to avoid aggregate function for increasing performance during like un nessary use of aggregate function used in optimization like that
regards
Mahesh
An Eternal "It Depends" - Removing the aggregations may or may not increase performance.
Can try things such as:
Again - all calculations are aggregations. It doesn't matter if you write an aggregation function or not, QlikView still needs to aggregate. Read the blog post.
If you want to increase performance, there are several things you can do, but avoiding using an aggregation function does not help. The three bullets in Jim Schepflin's answer are all things that potentially can improve performance.
HIC