Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @Zachary, to assing values you can use IntervalMatch. https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPre...
But interval need an start and end point of each date range, so first you need to cerarte those range, taking ValidDate as the start date you can create the end date using peek(), ie:
PricesWithIntervals:
LOAD Item,
StandarPrice,
ValidDate as StartDate,
If(Peek(Item)=Item, Date(Peek(StartDate)-1), Date(99999) as EndDate
Resident [ItemCalculationTableName]
Order by Price, ValidDate desc;
Hi @Zachary, to assing values you can use IntervalMatch. https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPre...
But interval need an start and end point of each date range, so first you need to cerarte those range, taking ValidDate as the start date you can create the end date using peek(), ie:
PricesWithIntervals:
LOAD Item,
StandarPrice,
ValidDate as StartDate,
If(Peek(Item)=Item, Date(Peek(StartDate)-1), Date(99999) as EndDate
Resident [ItemCalculationTableName]
Order by Price, ValidDate desc;