# QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

## If then loop

I have the following table:

 Date Entry type Item Qty GRN no. Vendor 1-Jan-16 GRN RBC12300 10 GRN-101 ABC 3-Jan-16 Sale RBC12300 -20 SRN-678 DEF 4-Jan-16 GRN RBC12300 30 GRN-102 CDE 5-Jan-16 Output RBC12300 25 ORN-345 RC! 6-Jan-16 GRN RBC12300 15 GRN-103 ABC 1-Feb-16 GRN RAC56789 10 GRN-101 ABC 3-Feb-16 Sale RAC56789 -20 SRN-678 DEF 4-Feb-16 GRN RAC56789 30 GRN-102 CDE 5-Feb-16 Output RAC56789 35 ORN-345 RC! 6-Feb-16 GRN RAC56789 15 GRN-103 ABC

Table 2:

 Closing stock of RBC 12300 60 Closing stock of RBC 12300 70

i need the following output :

The system should compare recent Receipts (GRN and Output)

with the closing stock. to the extent Receipts matches with the closing stock, it should consider.

 6-Jan-16 GRN RBC12300 GRN-103 15 5-Jan-16 Output RBC12300 ORN-345 25 4-Jan-16 GRN RBC12300 GRN-102 20 6-Feb-16 GRN RAC56789 GRN-103 15 5-Feb-16 Output RAC56789 ORN-345 25 4-Feb-16 GRN RAC56789 GRN-102 30

for eg. in the output for item RBC 12300, GRN Qty is 30, but only 20 is considered as the sum total is equal to 60.

kindly provide code for this in qlikview/

1 Reply
MVP

## Re: If then loop

I don't really understand your requested output description:

- Are you only considering records looking back to the last sale as 'recent'? Or why have you left out 1-Jan and 1-Feb receipts?

-"for eg. in the output for item RBC 12300, GRN Qty is 30, but only 20 is considered as the sum total is equal to 60."

I am totally lost, can't get how you calculate 30, then consider only 20????