How to generate monthly records based on data range?

[mszuberl]

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

[Anonymous]

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

[Anonymous · Accepted solution]

Hi,

Please find attached file and let me is this what you expected?

[mszuberl]

Jaswant,

Thank you very much!!

It works!

Marcin

[mszuberl]

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