If then loop

Mon, 26 Jan 2026 18:19:17 GMT

I have the following table:

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.

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/

Re: If then loop

swuehl — Fri, 10 Jun 2016 22:00:11 GMT

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????