enrol date is same for each ID. I need to calculate Scheduled dates for each ID which should be the increment of 7 from the previous date and loop it for 20 times.
Once scheduled date is calculated, I have to check for each ID, if a dose is taken in each week (in calc Scheduled Date column) If a dosed is missed is any of the week, that needs to be flagged.
You will need to build out a Master Calendar. (Search for that along with Qlik to find many examples)
You will want a calendar that has every single day along with some flags that say what week it is in. Qlik has a simple Week function.
Meaning if you consider this week let's say it is the 17'th week of the year. So Monday - Friday are all part of Week 17. If patient is dosed anytime this week, they are do again sometime in Week #18.
Thanks for providing with the great explanation on the approach to go ahead on the solution. I am very new to QlikSense, and I am already working the script with the approach suggested. But can someone help me by providing any reference to a script which has worked on the similar approach. This will help me a lot. Thanks
