Calculating Dates based on weeks from last Friday date

goro2010 — Sat, 16 Nov 2024 04:10:48 GMT

Good Day,

I hope someone would be able to assist me, I am looking to built a routing table from dates.

By having a pinned date, I would need to be able to generate dates based on the indicators.

For example, if I have an indicator called EV1, then every week from the pinned date, a date needs to be generated, if I should have an indicator like W13, then from the pinned date, there should only be one date generated for 13 weeks ahead.

Could someone please advise me if the above would be possible?

Thank You

Re: Calculating Dates based on weeks from last Friday date

qliksus — Thu, 14 Mar 2019 12:55:07 GMT

Not sure if u understood your issue clearly but you can add the value to be added in a loop and just add it . For EV1 you create a date after a week so pass the value as 7 for EV13 it should be 13 weeks ahead so it should be 91 put the number you want to add in each categotry and loop it

for each I in 7,91

load pinneddate
pinneddate + I as Date

autogenerate(1) ;

next

topic Re: Calculating Dates based on weeks from last Friday date in QlikView

Calculating Dates based on weeks from last Friday date

Re: Calculating Dates based on weeks from last Friday date