topic Best Data Model Suggestion in QlikView https://community.qlik.com/t5/QlikView/Best-Data-Model-Suggestion/m-p/600794#M1106703 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a scenario, wherein I have around <STRONG>10 excel dumps</STRONG>, for each month, of which 4 <STRONG>groups</STRONG> can be clubbed according to there simlilar nature of calculation.</P><P>Ex. Table A, A1 , B,B1,B2 ,&nbsp; C,C1,C3,&nbsp; D,D1.</P><P></P><P><STRONG>All of these dumps have 90% simlar fields in them.</STRONG></P><P></P><P>Current Data Model as best I could think of, I have calculated individual dump accordingly, Grouped and stored into respective group QVDs.</P><P>Now, I have <STRONG>concatenated</STRONG> these QVDs.</P><P></P><P>But the issue is the Load,becoz of this the application size has increased 300000 KB !!!</P><P></P><P>Please suggest on how to create the data Model in this scenario.</P><P></P><P>Thanks in advance !</P></BODY></HTML> Fri, 04 Apr 2014 05:58:49 GMT 2014-04-04T05:58:49Z Best Data Model Suggestion https://community.qlik.com/t5/QlikView/Best-Data-Model-Suggestion/m-p/600794#M1106703 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a scenario, wherein I have around <STRONG>10 excel dumps</STRONG>, for each month, of which 4 <STRONG>groups</STRONG> can be clubbed according to there simlilar nature of calculation.</P><P>Ex. Table A, A1 , B,B1,B2 ,&nbsp; C,C1,C3,&nbsp; D,D1.</P><P></P><P><STRONG>All of these dumps have 90% simlar fields in them.</STRONG></P><P></P><P>Current Data Model as best I could think of, I have calculated individual dump accordingly, Grouped and stored into respective group QVDs.</P><P>Now, I have <STRONG>concatenated</STRONG> these QVDs.</P><P></P><P>But the issue is the Load,becoz of this the application size has increased 300000 KB !!!</P><P></P><P>Please suggest on how to create the data Model in this scenario.</P><P></P><P>Thanks in advance !</P></BODY></HTML> Fri, 04 Apr 2014 05:58:49 GMT https://community.qlik.com/t5/QlikView/Best-Data-Model-Suggestion/m-p/600794#M1106703 2014-04-04T05:58:49Z Re: Best Data Model Suggestion https://community.qlik.com/t5/QlikView/Best-Data-Model-Suggestion/m-p/600795#M1106704 <HTML><HEAD></HEAD><BODY><P>Go to this link </P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4556">http://community.qlik.com/docs/DOC-4556</A></P></BODY></HTML> Fri, 04 Apr 2014 06:00:58 GMT https://community.qlik.com/t5/QlikView/Best-Data-Model-Suggestion/m-p/600795#M1106704 sujeetsingh 2014-04-04T06:00:58Z Re: Best Data Model Suggestion https://community.qlik.com/t5/QlikView/Best-Data-Model-Suggestion/m-p/600796#M1106705 <HTML><HEAD></HEAD><BODY><P>try joining if required</P><P>--Analyse the complete association of fields and keys.</P><P>---minimise number of qvd</P><P>---at last try to break the model with fact and dimension table </P></BODY></HTML> Fri, 04 Apr 2014 06:02:54 GMT https://community.qlik.com/t5/QlikView/Best-Data-Model-Suggestion/m-p/600796#M1106705 sujeetsingh 2014-04-04T06:02:54Z