Peek and create flag

[markgraham123]

Hello,

Here is my original data set in the application.

REQ field is just repeating.

Any help ism highly appreciated.

ITEM	Location	Available	AvailableDate	REQ	Can fill
1	Dallas	204	10/24/2017	104	104
1	Dallas	300	11/5/2017	104
1	Dallas	60	11/15/2017	104
1	Dallas	204	12/1/2017	104
1	Dallas	204	12/2/2017	104
2	Chicago	35	10/21/2017	2	2
2	Chicago	40	12/1/2017	2
2	Chicago	44	12/1/2017	2
2	NY	38	12/5/2017	3
2	NY	43	12/5/2017	3
3	Chicago	300	10/21/2017	250	250
3	Chicago	0	12/1/2017	2
3	Chicago	0	12/1/2017	2
3	NY	3	12/5/2017	400	3
3	NY	10	12/5/2017	3

[markgraham123]

I see only 204.

It is not 2014

[markgraham123]

Anil,

I see only 204.

Where do you see 2014?

[Anil_Babu_Samineni]

[markgraham123]

Oh.

I apologize.

It is a typo.

it should be 204

[sujith1011]

Please provide your expected output, with sample data

[Anil_Babu_Samineni]

What are these codes? Give some background what youtried and it helps to save sometime. We are fine with your expected result but no use of your explanation ..

Qlik Community Tip: How to Get Answers to Your Post

[markgraham123]

Sujith,

It should look for available qty and available date and create a new filed - 'Can Fill' with how much can it fill ?

ITEM	Location	Available	AvailableDate	REQ	Can fill
1	Dallas	204	10/24/2017	104	104
1	Dallas	300	11/5/2017	104
1	Dallas	60	11/15/2017	104
1	Dallas	204	12/1/2017	104
1	Dallas	204	12/2/2017	104
2	Chicago	35	10/21/2017	2	2
2	Chicago	40	12/1/2017	2
2	Chicago	44	12/1/2017	2
2	NY	38	12/5/2017	3
2	NY	43	12/5/2017	3
3	Chicago	300	10/21/2017	250	250
3	Chicago	0	12/1/2017	2
3	Chicago	0	12/1/2017	2
3	NY	3	12/5/2017	400	3
3	NY	10	12/5/2017	3

[sujith1011]

What about the data for ITem 1 Available 300 available date 11/5/2017 ,

is REQ 104, why is can fill blank, shouldn't it be 104 as well ?

[markgraham123]

Sujith,

104 is the just repeating quantity by Place and ITEM. (Nature of data)

Since, we got 104 for ITEM 1 and location Dallas at 10/24.

So, the demand 104 is closed.

[markgraham123]

Let me put it more simple.

I'm tring to create a logic with the below sample data:

ITEM	Incoming_Qty	Incoming Date	Required	Can fill
1	81	10/19/2017 0:00	126	81
1	122	11/1/2017 0:00		45
1	214	11/1/2017 0:00
1	233	11/9/2017 0:00

I have 126 units of demand.

I'm looking at when can i get my qty - I have multiple dates.

So, i see that i'm getting 81 on one date.

So, i can fill only 81 units.

Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.

Req O/P: 'Can fill' column in the above table.