Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Create a set of orders based on box size of Order

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.

QV Comm.png

1 Reply
Brett_Bleess
Employee
Employee

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.