topic Re: StarSchema datamodel in QlikView https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516516#M1141189 <HTML><HEAD></HEAD><BODY><P>Hi Raju,</P><P></P><P>What you can do is Left Join "ORDERS","ORDERSUMMARY" and "ORDER DETAILS"&nbsp; based on <STRONG>OrderID</STRONG> and all together you can left join it with "CUSTOMERS" based on <STRONG>CustomerID</STRONG><BR />.</P></BODY></HTML> Tue, 08 Oct 2013 11:54:24 GMT saumyashah90 2013-10-08T11:54:24Z StarSchema datamodel https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516513#M1141185 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P><STRONG>PFA</STRONG></P><P>I am Developed one application but i want starschema datamodel</P><P>Please any one can help (<STRONG>Starschema datamodel,)</STRONG></P><P></P><P>Thanks in Advance..</P></BODY></HTML> Mon, 07 Oct 2013 06:44:56 GMT https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516513#M1141185 Nagaraju_KCS 2013-10-07T06:44:56Z Re: StarSchema datamodel https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516514#M1141187 <HTML><HEAD></HEAD><BODY><P>Please anyone can help me.............</P></BODY></HTML> Mon, 07 Oct 2013 07:12:00 GMT https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516514#M1141187 Nagaraju_KCS 2013-10-07T07:12:00Z Re: StarSchema datamodel https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516515#M1141188 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Hi Raju,</SPAN></P><P><SPAN class="hps"></SPAN> </P><P><SPAN class="hps">I would advise</SPAN> <SPAN class="hps">you</SPAN> <SPAN class="hps">to put</SPAN> <SPAN class="hps">the tables</SPAN> <SPAN class="atn hps">"</SPAN>order", <SPAN class="atn hps">"</SPAN>ordersumary" <SPAN class="hps">and</SPAN> <SPAN class="atn hps">"</SPAN>OrderDetails" <SPAN class="hps">in one</SPAN>. <SPAN class="hps">Also</SPAN> <SPAN class="hps">assemble</SPAN> <SPAN class="hps">the tables</SPAN> <SPAN class="atn hps">"</SPAN>Divisions" <SPAN class="hps">and</SPAN> <SPAN class="atn hps">"</SPAN>Custumers" <SPAN class="hps">and</SPAN> <SPAN class="hps">finally</SPAN> <SPAN class="hps">the tables</SPAN> <SPAN class="hps">"products</SPAN>" <SPAN class="hps">and</SPAN> <SPAN class="atn hps">"</SPAN>categories" in this way <SPAN class="hps">you</SPAN> <SPAN class="hps">will have a</SPAN> <SPAN class="hps">perfect</SPAN> <SPAN class="hps">star schema</SPAN> <SPAN class="hps">model</SPAN>.</P></BODY></HTML> Tue, 08 Oct 2013 11:42:04 GMT https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516515#M1141188 2013-10-08T11:42:04Z Re: StarSchema datamodel https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516516#M1141189 <HTML><HEAD></HEAD><BODY><P>Hi Raju,</P><P></P><P>What you can do is Left Join "ORDERS","ORDERSUMMARY" and "ORDER DETAILS"&nbsp; based on <STRONG>OrderID</STRONG> and all together you can left join it with "CUSTOMERS" based on <STRONG>CustomerID</STRONG><BR />.</P></BODY></HTML> Tue, 08 Oct 2013 11:54:24 GMT https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516516#M1141189 saumyashah90 2013-10-08T11:54:24Z Re: StarSchema datamodel https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516517#M1141190 <HTML><HEAD></HEAD><BODY><P>Thank U very much.........both</P><P>ClaUdio and Saumya...</P></BODY></HTML> Wed, 09 Oct 2013 06:43:51 GMT https://community.qlik.com/t5/QlikView/StarSchema-datamodel/m-p/516517#M1141190 Nagaraju_KCS 2013-10-09T06:43:51Z