topic Re: Merge 2 data models in single qvw in QlikView https://community.qlik.com/t5/QlikView/Merge-2-data-models-in-single-qvw/m-p/1247364#M395316 <HTML><HEAD></HEAD><BODY><P>I don't think that you will get any performance improvements from splitting a datamodel but keeping them as two separate datamodels within a single qvw - rather the opposite. The splitting itself will give you performance advantages if you then used two or even more qvw's - and you might use some simple kind of document chaining to enable the users to switch from one to another.</P><P></P><P>Beside this there might be further possibilities to improve the application performance by only loading needed fields and removing such things like record-ID's, splitting timestamps and of course avoiding aggr-functions and nested if-loops within the UI could speed up an application significantly.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 21 Mar 2017 09:14:31 GMT marcus_sommer 2017-03-21T09:14:31Z Merge 2 data models in single qvw https://community.qlik.com/t5/QlikView/Merge-2-data-models-in-single-qvw/m-p/1247363#M395315 <HTML><HEAD></HEAD><BODY><P>Hi Friends , </P><P></P><P>I have one situation where i have 200 million records since 2014 ,and i have created one data model using the fact and some dimension tables , now i am planing to split that data model into 2 part because it is taking lot of time , </P><P></P><P>Previews Model</P><P>Current Year Model</P><P></P><P>After that i want to concat both qvw data in single qvw . everything will work fine but my dimension table data is getting duplicate. </P><P></P><P>How to avoid this situation , is there any solution for this or please suggest some other ways also.</P></BODY></HTML> Tue, 21 Mar 2017 06:41:12 GMT https://community.qlik.com/t5/QlikView/Merge-2-data-models-in-single-qvw/m-p/1247363#M395315 agni_gold 2017-03-21T06:41:12Z Re: Merge 2 data models in single qvw https://community.qlik.com/t5/QlikView/Merge-2-data-models-in-single-qvw/m-p/1247364#M395316 <HTML><HEAD></HEAD><BODY><P>I don't think that you will get any performance improvements from splitting a datamodel but keeping them as two separate datamodels within a single qvw - rather the opposite. The splitting itself will give you performance advantages if you then used two or even more qvw's - and you might use some simple kind of document chaining to enable the users to switch from one to another.</P><P></P><P>Beside this there might be further possibilities to improve the application performance by only loading needed fields and removing such things like record-ID's, splitting timestamps and of course avoiding aggr-functions and nested if-loops within the UI could speed up an application significantly.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 21 Mar 2017 09:14:31 GMT https://community.qlik.com/t5/QlikView/Merge-2-data-models-in-single-qvw/m-p/1247364#M395316 marcus_sommer 2017-03-21T09:14:31Z