Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See this blog post.


talk is cheap, supply exceeds demand
Not applicable
Author

thank you for the link. it helped a lot. 🙂

sohaib_hasan
Contributor II
Contributor II

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