Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

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.....