Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shahafei2
Creator
Creator

next fit algorithm bin packing in QV?

Hi all,

 

I'm wondering if there is a way to run a "next fit algorithm" in QV in order to calculate the minimum amount of cartons and movements

 

in my scenario i have 3 zones at the WH(A, B, C)

In each zone there are unique products and the amount of available inventory per product is known 

 

the carton volume and dimensions are fixed $(v_Car_vol),$(v_Car_length),$(v_Car_width),$(v_Car_width)

 

The DB is based on the following data 

 

Product:

ProductID,

Unit_length,

Unit_width

Unit_height

Unit_vol,

Zone,

Units_In_Inventory

 

Orders:

OrderID,

Delivery_Date,

Delivery_Time,

ProductID,

Qty

 

What will be the best way to calculate the amount of cartons  per order 

and to present the required daily movements of cartons between the different zones?

 

0 Replies