Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Peek and create flag

Hello,

Here is my original data set in the application.

REQ field is just repeating.

Any help ism highly appreciated.

     

ITEMLocationAvailableAvailableDateREQCan fill
1Dallas20410/24/2017104104
1Dallas30011/5/2017104
1Dallas6011/15/2017104
1Dallas20412/1/2017104
1Dallas20412/2/2017104
2Chicago3510/21/201722
2Chicago4012/1/20172
2Chicago4412/1/20172
2NY3812/5/20173
2NY4312/5/20173
3Chicago30010/21/2017250250
3Chicago012/1/20172
3Chicago012/1/20172
3NY312/5/20174003
3NY1012/5/2017

3

21 Replies
its_anandrjs

Hope you are looking this


Add new field as

if(REQ=Previous(REQ),' ' ,REQ) as NEW

markgraham123
Specialist
Specialist
Author

Anand,

I'm looking to calculate (Available - REQ) to see how many i can fill in the 'Can fill' column

markgraham123
Specialist
Specialist
Author

Anil_Babu_Samineni

Can you explain behind the logic? Atleast consider as 1 row to show output

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
its_anandrjs

Not clear please elaborate more of provide the expected output here to and understand the output.

markgraham123
Specialist
Specialist
Author

Item 1 has 104 units of requirement.

I'm getting 2014 units on 10/24.

So, i can fill those 104 units.

Now. i go to Item 3 at NY.

It needs 400 but i'm getting only 3 units on 12/25.

So, i can only fill 3

markgraham123
Specialist
Specialist
Author

Item 1 has 104 units of requirement.

I'm getting 2014 units on 10/24.

So, i can fill those 104 units.

Now. i go to Item 3 at NY.

It needs 400 but i'm getting only 3 units on 12/25.

So, i can only fill 3

Anil_Babu_Samineni

Again not clear, What is the value 2014 and 10/24?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sujith1011
Partner - Creator
Partner - Creator

Hey Mark,

Could you please provide a little more detail please

which one is a calculated field here, are you trying to calculate REQ, here ?

also

Item 1 has 104 units of requirement.

I'm getting 2014 units on 10/24.  where is 2014 coming from its not there in your example

if you could provide the value of REQ that should actually appear then it will be helpful