Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
karthikeyan1504
Creator III
Creator III

Help on supply chain concept

Hi,

I have got a requirement as explained below,

Capture.PNG


Please take an example of above data.

Avail OH is Available stock in warehouse.

There are two stores requesting for stock: Store A and Store B.

Store A is requesting for 4 (Propose) and Store B is requesting for 8 (Propose).

Store A has been allocated 4. So the remaining in ware house is (10-4) 6 and so Store B is allocated only 6.

The allocation would be in ascending order of store name.

Please note the warehouse can have any number of items and stores.

Could anyone please help on this to achieve it?

Thanks & Regards,

Karthikeyan.

4 Replies
sunny_talwar

And this is something you are trying to do in the script or front end?

karthikeyan1504
Creator III
Creator III
Author

In script I need to consider the looping method, but there would be millions of iteration.

Is there is a way to achieve in UI without the performance issue?

sunny_talwar

There might be ways to do it in UI, but I think back-end would be more efficient because this sort of thing is not filter dependent (at least that's how I see it). Would be better if calculated in the script.

Would you be able to provide few rows of raw data in any format other than image?

luciancotea
Specialist
Specialist

Sunny is right, this is a script job. No iterations required, just use peek() function.

But I would furfill requests based on sales performance desc, not alphabetically.

Another useful table that you can do in the interface is the existing stock optimisation, by moving excess stock from one store to another based on sales performance.

For chains with tens/hundreds of stores and thousands products, who is gonna provide requests for each product in each store? You have to calculate the request based on previous sales.