Create a set of orders based on box size of Order

[markgraham123]

Hi - Can someone please help?

I'm working on a requirement where i have to create a set of orders sorting data set from A to B(Orders column) in my Sample data set.

I want to create a shopping cart by allocating orders accounting to total size of 25.

Cart has 10 slots. Each slot can hold size of 2.5 utmost. So, my order set total size should be 25 (2.5*10).

Attached is the QV application and attached image depicts the desired O/P.

Can someone please help? Any help is highly appreciated.

[Brett_Bleess]

See duplicate post: https://community.qlik.com/t5/QlikView-Scripting/Create-a-set-of-orders-based-on-order-box-size/m-p/...

Regards,
Brett