Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

markgraham123
Not applicable

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
Not applicable

Re: Peek and create flag

Hope you are looking this


Add new field as

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

markgraham123
Not applicable

Re: Peek and create flag

Anand,

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

markgraham123
Not applicable

Re: Peek and create flag

loveisfail
Not applicable

Re: Peek and create flag

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

Life is so rich, and we need to respect to the life !!!
its_anandrjs
Not applicable

Re: Peek and create flag

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

markgraham123
Not applicable

Re: Peek and create flag

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
Not applicable

Re: Peek and create flag

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

loveisfail
Not applicable

Re: Peek and create flag

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

Life is so rich, and we need to respect to the life !!!
sujith1011
Not applicable

Re: Peek and create flag

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