Discussion Board for collaboration on QlikView Scripting.
I am pretty new to QlikView, currently experimenting a lot with scripting.
I am currently stuck on creating a table that would give me monthly eligibility records, based on eligibility range.
MemberID StartDt EndDt
A1 2010-01-01 2010-03-05
A2 2011-01-01 2011-02-25
I need to create a table that would have:
Does any one know how to do this? Any help is really appreciated!
Go to Solution.
Please find attached file and let me is this what you expected?
View solution in original post
Looks like you are in classic need of the Intervalmatch() function.
This IntervalMatch Blog Post by Henric is well worth looking at, I regularly read & refer to his Blog Posts and would highly recommend them.
Best Regards, Bill
Thank you very much!!
Thank you for your help!
I have seen Henric's blog a few times and he always has some great information there.
I will surely follow him from now on!