topic Re: Optimising data model in QlikView https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342586#M413436 <HTML><HEAD></HEAD><BODY><P>The usual model is a "Star"-scheme, so please check, whether you may concatenate the fact-table and organize other tables with a 1:n-relation as descriptive tables.</P><P></P><P>Else please post an example.</P></BODY></HTML> Mon, 15 May 2017 07:27:01 GMT prieper 2017-05-15T07:27:01Z Optimising data model https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342585#M413435 <HTML><HEAD></HEAD><BODY><DIV><P>I need to optimise my data model,it has around 15 tables,how to start with it</P></DIV></BODY></HTML> Mon, 15 May 2017 06:57:23 GMT https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342585#M413435 Anonymous 2017-05-15T06:57:23Z Re: Optimising data model https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342586#M413436 <HTML><HEAD></HEAD><BODY><P>The usual model is a "Star"-scheme, so please check, whether you may concatenate the fact-table and organize other tables with a 1:n-relation as descriptive tables.</P><P></P><P>Else please post an example.</P></BODY></HTML> Mon, 15 May 2017 07:27:01 GMT https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342586#M413436 prieper 2017-05-15T07:27:01Z Re: Optimising data model https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342587#M413437 <HTML><HEAD></HEAD><BODY><P>Have a look at this blog on how to do Optimised Loads</P><P></P><P><A href="https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/" title="https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/">https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/</A></P></BODY></HTML> Mon, 17 Jul 2017 15:37:56 GMT https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342587#M413437 ngulliver 2017-07-17T15:37:56Z Re: Optimising data model https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342588#M413438 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">please close your <A _jive_internal="true" class="jiveTT-hover-user jive-link-profile-small" data-containerid="-1" data-containertype="-1" data-objectid="242444" data-objecttype="3" href="https://community.qlik.com/people/dynamic_girl/content" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">open threads</A> that received correct answers:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2001" data-containertype="14" data-objectid="14806" data-objecttype="102" href="https://community.qlik.com/docs/DOC-14806" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">thanks</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">regards</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Marco</P></BODY></HTML> Wed, 19 Jul 2017 00:06:40 GMT https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342588#M413438 MarcoWedel 2017-07-19T00:06:40Z Re: Optimising data model https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342589#M413439 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm glad you found the linked Community Tip helpful.</P><P>Have you already been able to check your threads for correct answers and close the ones you found?</P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 22 Jul 2017 20:08:39 GMT https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342589#M413439 MarcoWedel 2017-07-22T20:08:39Z Re: Optimising data model https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342590#M413440 <HTML><HEAD></HEAD><BODY><P>yes sir</P><P>most of them</P><P>thanks</P></BODY></HTML> Tue, 25 Jul 2017 06:40:03 GMT https://community.qlik.com/t5/QlikView/Optimising-data-model/m-p/1342590#M413440 Anonymous 2017-07-25T06:40:03Z