Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to create auto-generated months based on start date and end date

Hi,

I have this data:

wave.jpg

I need to generate duplicate rows of Wave_ID from Start Date to End Date in months.

I need the result to be like this:

wave-2.jpg

Any idea how to do this in qlikview?

Thanks a lot!

-Rhea

Tags (2)
3 Replies

Re: How to create auto-generated months based on start date and end date

See this blog post.


talk is cheap, supply exceeds demand
Not applicable

Re: How to create auto-generated months based on start date and end date

thank you for the link. it helped a lot. :-)

sohaib_hasan
New Contributor

Re: How to create auto-generated months based on start date and end date

Dear Rahe, same requirement here .. plz share if your 've done.....

Community Browser