topic Question on Loading records in QlikView https://community.qlik.com/t5/QlikView/Question-on-Loading-records/m-p/219953#M72914 <HTML><HEAD></HEAD><BODY><P></P><P>Hello,</P><P>I have loaded Qlikview table using script as below based on shipment Appointment &amp; Arrival date/time. Idea is to find Ontime performance of shipments.</P><P>Some shipments have multiple stops and within same shipments (ex. CS00697697) certain stops ontime and other stops were not. Hence, QV loading stores two records for this shipment - one for <STRONG>Ontime</STRONG> and second for <STRONG>OutOfTime</STRONG>. I wanted to load QV table to show on shipment record, if any <STRONG>ONE</STRONG> of the stop is OutOfTime than wanted to flag that shipment as <STRONG>'1'</STRONG> and wanted to eliminate record for that shipment that has <STRONG>'0'</STRONG>.</P><P>Values '0' represents Ontime and '1' OutOfTime.</P><P>I need some help/hints in Qlikview loading script to achieve my goal. Could you please suggest.</P><P>Thanks.</P><P>Siva</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-910_sourceID:910" /></P></BODY></HTML> Fri, 22 Jan 2010 00:38:49 GMT 2010-01-22T00:38:49Z Question on Loading records https://community.qlik.com/t5/QlikView/Question-on-Loading-records/m-p/219953#M72914 <HTML><HEAD></HEAD><BODY><P></P><P>Hello,</P><P>I have loaded Qlikview table using script as below based on shipment Appointment &amp; Arrival date/time. Idea is to find Ontime performance of shipments.</P><P>Some shipments have multiple stops and within same shipments (ex. CS00697697) certain stops ontime and other stops were not. Hence, QV loading stores two records for this shipment - one for <STRONG>Ontime</STRONG> and second for <STRONG>OutOfTime</STRONG>. I wanted to load QV table to show on shipment record, if any <STRONG>ONE</STRONG> of the stop is OutOfTime than wanted to flag that shipment as <STRONG>'1'</STRONG> and wanted to eliminate record for that shipment that has <STRONG>'0'</STRONG>.</P><P>Values '0' represents Ontime and '1' OutOfTime.</P><P>I need some help/hints in Qlikview loading script to achieve my goal. Could you please suggest.</P><P>Thanks.</P><P>Siva</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-910_sourceID:910" /></P></BODY></HTML> Fri, 22 Jan 2010 00:38:49 GMT https://community.qlik.com/t5/QlikView/Question-on-Loading-records/m-p/219953#M72914 2010-01-22T00:38:49Z