topic QVD/Data Model efficiencies in QlikView https://community.qlik.com/t5/QlikView/QVD-Data-Model-efficiencies/m-p/1127419#M370986 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am extracting and translating SQLs into QVDs and then further manipulating those QVDs into their quasi-final shape.</P><P></P><P>For the final build of the app, these ETL-shape QVDs are loaded and have a couple of processes run (generally a couple of things like cleaning nulls, adding flags, joining a couple of extra fields etc. - this isn't done in the pre-final qvd's as I am using them for staged releases of a dashboard).</P><P></P><P>The question is, is it more efficient (or does it make any difference at all) if I re-store the final shaped QVDs and then use a final-final QVD instead of using a mostly-final QVD and modifying it?</P><P></P><P></P><P>Cheers,</P><P></P><P>Lee</P></BODY></HTML> Thu, 01 Sep 2016 05:29:21 GMT 2016-09-01T05:29:21Z QVD/Data Model efficiencies https://community.qlik.com/t5/QlikView/QVD-Data-Model-efficiencies/m-p/1127419#M370986 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am extracting and translating SQLs into QVDs and then further manipulating those QVDs into their quasi-final shape.</P><P></P><P>For the final build of the app, these ETL-shape QVDs are loaded and have a couple of processes run (generally a couple of things like cleaning nulls, adding flags, joining a couple of extra fields etc. - this isn't done in the pre-final qvd's as I am using them for staged releases of a dashboard).</P><P></P><P>The question is, is it more efficient (or does it make any difference at all) if I re-store the final shaped QVDs and then use a final-final QVD instead of using a mostly-final QVD and modifying it?</P><P></P><P></P><P>Cheers,</P><P></P><P>Lee</P></BODY></HTML> Thu, 01 Sep 2016 05:29:21 GMT https://community.qlik.com/t5/QlikView/QVD-Data-Model-efficiencies/m-p/1127419#M370986 2016-09-01T05:29:21Z Re: QVD/Data Model efficiencies https://community.qlik.com/t5/QlikView/QVD-Data-Model-efficiencies/m-p/1127420#M370987 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>the final qvw should be the result of a Binary Load from the qvw QlikMart</P><P></P><P>Please see the attachment</P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Thu, 01 Sep 2016 15:12:08 GMT https://community.qlik.com/t5/QlikView/QVD-Data-Model-efficiencies/m-p/1127420#M370987 agomes1971 2016-09-01T15:12:08Z