Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-01-21 07:38 PM

Question on Loading records

Hello,

I have loaded Qlikview table using script as below based on shipment Appointment & Arrival date/time. Idea is to find Ontime performance of shipments.

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 Ontime and second for OutOfTime. I wanted to load QV table to show on shipment record, if any ONE of the stop is OutOfTime than wanted to flag that shipment as '1' and wanted to eliminate record for that shipment that has '0'.

Values '0' represents Ontime and '1' OutOfTime.

I need some help/hints in Qlikview loading script to achieve my goal. Could you please suggest.

Thanks.

Siva

error loading image

256 Views
0 Likes
0 Replies