https://community.qlik.com/t5/App-Development/Chart-doesnt-load-because-of-quantity-of-data-and-time-that/m-p/2436620#M97047 <P>Hello&nbsp;<BR />there are several factors that affect on the performance of your expressions but mainly it is the schema that has major effect.<BR /><BR />if you have a measure for example that has "components" from several fact tables in your schema, then here you might need to maybe join those fact tables into one and do part of the calculation in the script:<BR />ex:<BR />sum(field1, field2)<BR />field1 is in Table1, and field2 is in Table2<BR />then join Table1 and Table2 into a table named FACT for example<BR />then in this new table you create a new field which is field1+field2 as field3<BR /><BR />then your expression would be sum(field3)</P> Tue, 02 Apr 2024 08:18:06 GMT ali_hijazi 2024-04-02T08:18:06Z https://community.qlik.com/t5/App-Development/Chart-doesnt-load-because-of-quantity-of-data-and-time-that/m-p/2436609#M97046 <P>Hello everyone,&nbsp;</P> <P>so I created a container with two huge list with lots of formulas, and a button, when you click it, you have the option to chose the list u want to see. the thing is, when i click it, takes ages to load and it ends up giving me an error.&nbsp;</P> <P>how could i solve this?</P> <P>&nbsp;</P> <P>thanks</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:00:57 GMT https://community.qlik.com/t5/App-Development/Chart-doesnt-load-because-of-quantity-of-data-and-time-that/m-p/2436609#M97046 Nemo1 2024-11-15T21:00:57Z https://community.qlik.com/t5/App-Development/Chart-doesnt-load-because-of-quantity-of-data-and-time-that/m-p/2436620#M97047 <P>Hello&nbsp;<BR />there are several factors that affect on the performance of your expressions but mainly it is the schema that has major effect.<BR /><BR />if you have a measure for example that has "components" from several fact tables in your schema, then here you might need to maybe join those fact tables into one and do part of the calculation in the script:<BR />ex:<BR />sum(field1, field2)<BR />field1 is in Table1, and field2 is in Table2<BR />then join Table1 and Table2 into a table named FACT for example<BR />then in this new table you create a new field which is field1+field2 as field3<BR /><BR />then your expression would be sum(field3)</P> Tue, 02 Apr 2024 08:18:06 GMT https://community.qlik.com/t5/App-Development/Chart-doesnt-load-because-of-quantity-of-data-and-time-that/m-p/2436620#M97047 ali_hijazi 2024-04-02T08:18:06Z