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

How to generate monthly records based on data range?

mszuberl — Thu, 14 Nov 2013 18:30:02 GMT

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 — Thu, 14 Nov 2013 19:41:32 GMT

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 — Thu, 14 Nov 2013 20:53:22 GMT

Hi,

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

mszuberl — Thu, 14 Nov 2013 21:26:27 GMT

Jaswant,

Thank you very much!!

It works!

Marcin

mszuberl — Thu, 14 Nov 2013 21:34:57 GMT

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