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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nellie115
Contributor II
Contributor II

Need help in identifying what customers have orders shipping daily

HI all, 

Thank you for reading this. I'm working on a consolidation project where I am trying to find the best way to isolate the customers that have orders shipping on consecutive days. For example Customer A has orders that shipped today, tomorrow, Wed, Thurs, Monday, Tues, Wed. 

Any help would be greatly appreciated. 

 

2 Replies
Channa
Specialist III
Specialist III

attach sample data,ShipCustomer will brings repeated shipping customers on consecutive dates

 

load

Customer,ShippiingDate,
if(peek(Customer)=Customer and Shippingflag='Y' ,Customer )as CustomerDa,

if(peek(Customer)=Customer and Shippingflag='Y' and peek(ShippiingDate) =date(ShippiingDate-1), Customer )as ShipCustomer;

LOAD
Customer,
Shippingflag,
ShippiingDate
FROM [lib://com/Shipping.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

Channa
Nellie115
Contributor II
Contributor II
Author

Thank you Channa, what exactly does the shipping flag represent with Y and N?