topic Re: need help in QlikView https://community.qlik.com/t5/QlikView/need-help/m-p/111543#M758521 <HTML><HEAD></HEAD><BODY><P>can anyone helpplease</P></BODY></HTML> Mon, 10 Sep 2018 12:08:49 GMT qlikapple 2018-09-10T12:08:49Z need help https://community.qlik.com/t5/QlikView/need-help/m-p/111542#M758520 <HTML><HEAD></HEAD><BODY><P>Hi all ,</P><P> i have incidents, changeorders .</P><P>Incident:</P><P>Load* inline [</P><P>InNo, Opendatetime,CIName</P><P>123,11/4/2017&nbsp; 12:00:00 AM, Keyboard</P><P>124,11/4/2017&nbsp; 02:00:00 AM,Mouse</P><P>125,11/4/2017&nbsp; 2:00:00 AM,laptop</P><P>];</P><P></P><P>Similarly</P><P></P><P>Changeorder:</P><P>CRNo, scheduleddatetime,CIName</P><P>CR123,11/4/2017&nbsp; 12:00:00 AM, Keyboard</P><P>CR124,11/4/2017&nbsp; 02:00:00 AM,Mouse</P><P>CR 125,11/4/2017&nbsp; 2:00:00 AM,laptop,</P><P>CR 125,11/4/2017&nbsp; 2:30:00 AM,Speaker,</P><P>CR 125,11/4/2017&nbsp; 2:00:00 AM,Memorcard,</P><P>CR 125,11/4/2017&nbsp; 3:00:00 AM,laptop</P><P>];</P><P></P><P>Now my requirement&nbsp; is need create a staright table&nbsp; as based on&nbsp; Same CINames</P><P>How many Incidents are opened during the changeorders scheduleddatetime.</P><P>i want be in this format</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213119_pastedImage_115.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/111542#M758520 qlikapple 2020-11-25T16:16:04Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/111543#M758521 <HTML><HEAD></HEAD><BODY><P>can anyone helpplease</P></BODY></HTML> Mon, 10 Sep 2018 12:08:49 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/111543#M758521 qlikapple 2018-09-10T12:08:49Z