Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mszuberl
New Contributor II

How to generate monthly records based on data range?

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

1 Solution

Accepted Solutions
jaswantc
Contributor II

Re: How to generate monthly records based on data range?

Hi,

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

4 Replies

Re: How to generate monthly records based on data range?

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

jaswantc
Contributor II

Re: How to generate monthly records based on data range?

Hi,

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

mszuberl
New Contributor II

Re: How to generate monthly records based on data range?

Jaswant,

Thank you very much!!

It works!

Marcin

mszuberl
New Contributor II

Re: How to generate monthly records based on data range?

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

Community Browser