need help

[qlikapple]

Hi all ,

i have incidents, changeorders .

Incident:

Load* inline [

InNo, Opendatetime,CIName

123,11/4/2017  12:00:00 AM, Keyboard

124,11/4/2017  02:00:00 AM,Mouse

125,11/4/2017  2:00:00 AM,laptop

];

Similarly

Changeorder:

CRNo, scheduleddatetime,CIName

CR123,11/4/2017  12:00:00 AM, Keyboard

CR124,11/4/2017  02:00:00 AM,Mouse

CR 125,11/4/2017  2:00:00 AM,laptop,

CR 125,11/4/2017  2:30:00 AM,Speaker,

CR 125,11/4/2017  2:00:00 AM,Memorcard,

CR 125,11/4/2017  3:00:00 AM,laptop

];

Now my requirement  is need create a staright table  as based on  Same CINames

How many Incidents are opened during the changeorders scheduleddatetime.

i want be in this format

[qlikapple]

can anyone helpplease