topic Data-model in QlikView in QlikView https://community.qlik.com/t5/QlikView/Data-model-in-QlikView/m-p/48754#M8085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a xls, Where 5 Sheet are available. All the fields are different in each sheet and where jm_v_rep_topfeat_relation Sheet have the 3 Fields Where all the Combination are linked with another 4 Sheets. i.e : TFEAT_DOCUMENTKAY, RELATED_DOCUMENTKEY and RL_NAME. If you will check this fields value you can assume how it combined with another 4 sheets value.</P><P></P><P>Please find the attached xls and QVW for Data and code. I have tried by using linking model, but it is creating Cartesian Product (Cross Join) and going in loop.</P><P></P><P>QVW is in Debug mode, Not Full reload, When I am making full reload, data is going upto 70 Million. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>So Please Can anyone help me for making a relation with all 5 sheet / fields.</P><P></P><P>Thanks &amp; Regards,</P><P>AK</P></BODY></HTML> Tue, 19 Jun 2018 14:24:37 GMT sona_sa 2018-06-19T14:24:37Z Data-model in QlikView https://community.qlik.com/t5/QlikView/Data-model-in-QlikView/m-p/48754#M8085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a xls, Where 5 Sheet are available. All the fields are different in each sheet and where jm_v_rep_topfeat_relation Sheet have the 3 Fields Where all the Combination are linked with another 4 Sheets. i.e : TFEAT_DOCUMENTKAY, RELATED_DOCUMENTKEY and RL_NAME. If you will check this fields value you can assume how it combined with another 4 sheets value.</P><P></P><P>Please find the attached xls and QVW for Data and code. I have tried by using linking model, but it is creating Cartesian Product (Cross Join) and going in loop.</P><P></P><P>QVW is in Debug mode, Not Full reload, When I am making full reload, data is going upto 70 Million. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>So Please Can anyone help me for making a relation with all 5 sheet / fields.</P><P></P><P>Thanks &amp; Regards,</P><P>AK</P></BODY></HTML> Tue, 19 Jun 2018 14:24:37 GMT https://community.qlik.com/t5/QlikView/Data-model-in-QlikView/m-p/48754#M8085 sona_sa 2018-06-19T14:24:37Z