Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
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.
I have:
Elig_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:
MemberID Year_Month
A1 2010-01
A1 2010-02
A1 2010-03
A2 2011-01
A2 2011-02
Does any one know how to do this? Any help is really appreciated!
Marcin
Marcin
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
Hi,
Please find attached file and let me is this what you expected?
Jaswant,
Thank you very much!!
It works!
Marcin
Bill,
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!
Marcin