Date loop

Anonymous — Wed, 25 Jul 2018 08:58:49 GMT

I have a table which includes claims from the distributor for many part numbers with unique date of shipment.I need to verify whether these claims are correct.

To do the same,I have maintained various updated matrix updated files for each month with different dates,to check the claim

My Issue is,For example if date of shipment is 25/04/18 in claim file,then it should refer the matrix file with the name of 24/04/18 via a linked key.

If it not matches, then it should keep checking the earlier date's of matrix till then the condition is satisfied via key.

After that it should take the value from that file,so that i could verify whether the claim is correct.

Have already linked those two tables,need some help to apply this logic.

Thanks

topic Date loop in QlikView

Date loop