Loop Through Dates

krisslax — Thu, 27 Jan 2022 12:15:03 GMT

Hello - I have a table with a list of Assets:

ObjectID	ObjectType
AssetA1	Type1
AssetA2	Type2
AssetB1	Type3
AssetB2	Type3
AssetC1	Type1

And another table with a list of measurements:

ObjectID	MeasurementDate	MeasurementValue
AssetA1	02/01/2022	20
AssetB1	02/01/2022	45
AssetC1	03/01/2022	60
AssetA1	04/01/2022	26
AssetB1	26/12/2021	35
AssetC1	20/11/2021	45

What I want to do is create a new table with the date of 01/01/2022, which then loads each asset and adds the MAX measurement with a date less than 01/01/2022, then loops back subtracting a month from the date to go to 01/12/2021 and loads the MAX measurement again, until it hits 2018.

So essentially it's a history of the measurements taken, going back in time so I can track the measurements over a date range on a line chart.

Hope that makes sense.

Thanks in advance
-Kriss

topic Loop Through Dates in QlikView

Loop Through Dates