Spreadsheet: 525517d1498753968-need-help-with-a-complicated-lookup-qlikview-test-file
Sheet: Data for Qlikview

 |  | Manual | ASNs Received | ASNs Open | POs Open | Received Qty | Returns Received Qty | Putaway Qty | Pending Putaway Qty | Pending Putaway SKU Count | Oldest LPN Date | Orders Dropped | Orders Waved | Orders Manifested | Orders Shipped | Orders Shipped Same Day | Orders Cancelled | Units Dropped | Units [NAME] | Units Picked | Units Packed | Units Manifested | Units [NAME] | Units [NAME] | Units Cancelled | Orders Older Than 48 Hours | Oldest Order | Orders Released | VAS Orders Dropped | VAS Orders Waved | VAS Orders Shipped | Total Pick Task | Total Pick Task Completed | Multi Pick Tasks | Multi Pick Task Completed | Singles Pick Task | Singles Pick Task Completed | Total Wave Replen Tasks | Total Wave Replen Task Completed | Total Wave Replen Units Completed | Total Lean Replen Task | Total Lean Replen Task Completed | Total Lean Replen Untis Completed | [NAME] | Total Inventory Qty | Allocatable SKU Qty | Total SKU Qty | Transitional Inventory Qty | Transitional SKU Qty | Units Counted | Possitve Adjustments | Neative Adjustments | Active Locations Counted | Active Positive Adjustments | Active Negative Locations | Reserve Locations Counted | Reserve Positive Adjestments | Reserve Negative Adjustments | Total Active Locations | Total Active Locations in Use | Total Active Locations Locked | Active locations Created Today | Active Locations With Negative on Hand | Active Locations With Multiple SKUs | Active Locations With Zero On Hand | Items Without an Active Location | Items with Multiple Actives | Active Locations With Multiple SKUs | Total Reserve Locations | Total Reserve Locations In Use | Total Reserve Locations Locked | Reserve Locations Created Today | Reserve Locations With Negative On Hand | Reserve Locations With Multiple SKUs | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | ADP | Manual | Manual
KPI_DATE | WHS ID | Customer Trucks Arrived | Customer ASN's Received | Customer Unverified ASN's | Customer PO's Received | Customer Units Received | Customer Return Units Received | Customer Units Put Away | Customer Units Pending Putaway | Customer SKU's Pending Putaway | Customer Date of Oldest Pending Putaway LPN | Customer  Outbound (Header) | Customer Orders Dropped | Customer Orders Waved | Customer Orders Manifested | Customer Orders Shipped (regardless of create date) | Customer Orders Shipped Same Day | Customer Orders Cancelled | Customer Units Dropped | Customer Units [NAME] | Customer Units Picked | Customer Units Packed | Customer Units Manifested | Customer Units [NAME] (regardless of create date) | Customer Units [NAME] | Customer Units Cancelled | Customer Open Orders > 48 Hours | Customer Date of Oldest Open Order | Customer Orders Not Yet [NAME] | Total VAS Orders dropped | Total VAS Orders waved | Total VAS Orders shipped | Total Pick Tasks Created | Total Pick Tasks Completed | Total Multi Pick Tasks Created | Total Multi Pick Tasks Completed | Total Single Pick Tasks created | Total Single pick tasks Completed | Total Wave Generated Replenishment Tasks Created | Total Wave Generated Replenishment Tasks Completed | Total Wave Generated Replenishment Units Completed | Total Lean Time Replenishment Tasks Created | Total Lean Time Replenishment Tasks Completed | Total Lean Time Replenishment Units Completed | Customer Allocateable Units on Hand | Customer Total Units on Hand | Customer Allocateable SKU's on Hand | Customer Total SKU's on Hand | Units in Transitional Inventory | SKUs in Transitional Inventory | Customer Units Cycle Counted | Customer Units Added into Inventory | Customer Units Subtracted from Inventory | Active Locations Cycle Counted | Active Locations with Units Added into Inventory | Active Locations with Units Subtracted from Inventory | Reserve Locations Cycle Counted | Reserve Locations with Units Added into Inventory | Reserve Locations with Units Subtracted from Inventory | Total Active Locations | Total Active Locations Used | Total Active Locations Locked | Active Locations Activated/Created | Active Locations with Negative Balance on Hand | Active Locations with Multiple SKUs | # of Active Locations with Zero Balance on Hand | # of Items with Inventory and No Active Location | # of Items with Multiple Active Locations | # of Active Locations with Multiple Item Assignments | Total Reserve Locations | Total Reserve Locations Used | Total Reserve Locations Locked | Reserve Locations Activated/Created | Reserve Locations with Negative Balance on Hand | Reserve Locations with Multiple SKUs | Direct Reg Hours | Direct OT Hours | Direct Temp Reg Hours | Direct Temp OT Hours | Total Direct Hours | Indirect Reg Hours | Indirect OT Hours | Indirect Temp Reg Hours | Indirect Temp OT Hours | Total Indirect Hours | Clerical Reg Hours | Clerical OT Hours | Clerical Temp Reg Hours | Clerical Temp OT Hours | Total Clerical Hours | Total Direct Indirect Clerical Hours | OSHA Recordables | OSHA Recordable Rate
2017-06-22 00:00:00 |  |  | 7
2017-06-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 902
2017-06-24 00:00:00
2017-06-25 00:00:00
2017-06-26 00:00:00
2017-06-27 00:00:00
2017-06-28 00:00:00
2017-06-29 00:00:00
2017-06-30 00:00:00
2017-07-01 00:00:00
2017-07-02 00:00:00
2017-07-03 00:00:00
2017-07-04 00:00:00
2017-07-05 00:00:00
2017-07-06 00:00:00
2017-07-07 00:00:00
2017-07-08 00:00:00
2017-07-09 00:00:00
2017-07-10 00:00:00