Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
mszuberl
New Contributor III

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?

View solution in original post

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?

View solution in original post

mszuberl
New Contributor III

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

Jaswant,

Thank you very much!!

It works!

Marcin

mszuberl
New Contributor III

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