topic Expression optimization in QlikView https://community.qlik.com/t5/QlikView/Expression-optimization/m-p/1018249#M930635 <HTML><HEAD></HEAD><BODY><P>In my dashboard loading time is very high.</P><P></P><P>it has large data and complex expression how it can be optimzed?</P><P></P><P></P><P>Regards </P><P></P><P>Stephen G<IMG alt="loading time.png" class="jive-image image-1" src="/legacyfs/online/117200_loading time.png" style="height: 179px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT stephenedberkg 2020-11-25T16:16:04Z Expression optimization https://community.qlik.com/t5/QlikView/Expression-optimization/m-p/1018249#M930635 <HTML><HEAD></HEAD><BODY><P>In my dashboard loading time is very high.</P><P></P><P>it has large data and complex expression how it can be optimzed?</P><P></P><P></P><P>Regards </P><P></P><P>Stephen G<IMG alt="loading time.png" class="jive-image image-1" src="/legacyfs/online/117200_loading time.png" style="height: 179px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-optimization/m-p/1018249#M930635 stephenedberkg 2020-11-25T16:16:04Z Re: Expression optimization https://community.qlik.com/t5/QlikView/Expression-optimization/m-p/1018250#M930636 <HTML><HEAD></HEAD><BODY><P>That's hard to answer without having a look at your data model, data and expressions used.</P><P></P><P>Maybe start with this thread and go through all best practices, check if they are applicable to your expressions and model:</P><P><A href="https://community.qlik.com/thread/18473">*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****</A></P></BODY></HTML> Mon, 07 Mar 2016 12:55:04 GMT https://community.qlik.com/t5/QlikView/Expression-optimization/m-p/1018250#M930636 swuehl 2016-03-07T12:55:04Z Re: Expression optimization https://community.qlik.com/t5/QlikView/Expression-optimization/m-p/1018251#M930637 <HTML><HEAD></HEAD><BODY><P>Your question is very general without much supporting information about what you mean by "large data", "complex expressions" and "high loading time".</P><P></P><P>If you give us some numbers. How many rows, how many columns, what is "high loading time" in minutes? How many tables in the load? How many operations between the tables (joins etc) and operations with the tables (transformations/calculations)? </P><P></P><P>What do you mean by complex expressions? Do you have some examples. How many complex expressions do you use per chart? Do you have one or many charts that show low performance?</P></BODY></HTML> Mon, 07 Mar 2016 13:06:40 GMT https://community.qlik.com/t5/QlikView/Expression-optimization/m-p/1018251#M930637 petter 2016-03-07T13:06:40Z