topic Re: Help on supply chain concept in QlikView

Help on supply chain concept

karthikeyan1504 — Wed, 20 Apr 2016 08:11:41 GMT

Hi,

I have got a requirement as explained below,

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.

Re: Help on supply chain concept

sunny_talwar — Wed, 20 Apr 2016 08:14:42 GMT

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

Re: Help on supply chain concept

karthikeyan1504 — Wed, 20 Apr 2016 08:20:31 GMT

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?

Re: Help on supply chain concept

sunny_talwar — Wed, 20 Apr 2016 08:24:35 GMT

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?

Re: Help on supply chain concept

luciancotea — Wed, 20 Apr 2016 08:57:17 GMT

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.