topic Item code in one line in QlikView https://community.qlik.com/t5/QlikView/Item-code-in-one-line/m-p/62119#M10355 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have done something wrong in my data model please correct me .</P><P></P><P>PFA . </P><P></P><P>also find expected output excel.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 07 May 2018 12:15:33 GMT prma7799 2018-05-07T12:15:33Z Item code in one line https://community.qlik.com/t5/QlikView/Item-code-in-one-line/m-p/62119#M10355 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have done something wrong in my data model please correct me .</P><P></P><P>PFA . </P><P></P><P>also find expected output excel.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 07 May 2018 12:15:33 GMT https://community.qlik.com/t5/QlikView/Item-code-in-one-line/m-p/62119#M10355 prma7799 2018-05-07T12:15:33Z Re: Item code in one line https://community.qlik.com/t5/QlikView/Item-code-in-one-line/m-p/62120#M10356 <HTML><HEAD></HEAD><BODY><P>Would you be able to share&nbsp; Margin.qvd and FACT_SalesInvoice_Transaction.qvd</P></BODY></HTML> Mon, 07 May 2018 12:37:17 GMT https://community.qlik.com/t5/QlikView/Item-code-in-one-line/m-p/62120#M10356 sunny_talwar 2018-05-07T12:37:17Z Re: Item code in one line https://community.qlik.com/t5/QlikView/Item-code-in-one-line/m-p/62121#M10357 <HTML><HEAD></HEAD><BODY><P>It seems that you have some records not defined on "FACT_ValueEntry" Table.</P><P>As you can see there are lots of "%VE_Key" without Item_Code.</P><P><IMG alt="2018-05-07 14_42_06-QlikView x64 - Copia del rivenditore - [C__Users_denardm1_Downloads_Cogs Test2.q.png" class="jive-image image-1" src="/legacyfs/online/201670_2018-05-07 14_42_06-QlikView x64 - Copia del rivenditore - [C__Users_denardm1_Downloads_Cogs Test2.q.png" style="height: auto;" /></P></BODY></HTML> Mon, 07 May 2018 12:45:21 GMT https://community.qlik.com/t5/QlikView/Item-code-in-one-line/m-p/62121#M10357 micheledenardi 2018-05-07T12:45:21Z