topic Re: Data model optimisation in QlikView https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49045#M8141 <HTML><HEAD></HEAD><BODY><P>Try to Merge small tables into one table and you use apply mapping also.</P></BODY></HTML> Wed, 18 Apr 2018 10:19:47 GMT Anonymous 2018-04-18T10:19:47Z Data model optimisation https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49040#M8136 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P>I have this data model and i would like to minimize the number of tables <IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199890_Capture.PNG" style="height: 270px; width: 620px;" /></P><P>any suggestions ? thanks </P></BODY></HTML> Tue, 17 Apr 2018 12:32:43 GMT https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49040#M8136 zied_ahmed1 2018-04-17T12:32:43Z Re: Data model optimisation https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49041#M8137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>to reduce the amount of tables (for optimization and aesthetic needs maybe) you can join many tables to your central table.</P></BODY></HTML> Tue, 17 Apr 2018 12:41:48 GMT https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49041#M8137 YoussefBelloum 2018-04-17T12:41:48Z Re: Data model optimisation https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49042#M8138 <HTML><HEAD></HEAD><BODY><P>as soon as you understand the meaning of each of these tables, there is a lot of work that must be done here, in fact I think the tables were loaded without modeling at all.</P></BODY></HTML> Tue, 17 Apr 2018 12:49:13 GMT https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49042#M8138 YoussefBelloum 2018-04-17T12:49:13Z Re: Data model optimisation https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49043#M8139 <HTML><HEAD></HEAD><BODY><P>you should use dimensional model to optimize your data model.</P></BODY></HTML> Tue, 17 Apr 2018 15:24:09 GMT https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49043#M8139 jafari_ervin 2018-04-17T15:24:09Z Re: Data model optimisation https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49044#M8140 <HTML><HEAD></HEAD><BODY><P>Try to use Applymap for 2-dimensional tables, as many as possible. </P></BODY></HTML> Tue, 17 Apr 2018 20:41:34 GMT https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49044#M8140 Venkatchoudary 2018-04-17T20:41:34Z Re: Data model optimisation https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49045#M8141 <HTML><HEAD></HEAD><BODY><P>Try to Merge small tables into one table and you use apply mapping also.</P></BODY></HTML> Wed, 18 Apr 2018 10:19:47 GMT https://community.qlik.com/t5/QlikView/Data-model-optimisation/m-p/49045#M8141 Anonymous 2018-04-18T10:19:47Z