Skip to main content

Qlik

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
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

207 Views
0 Likes
0 Replies