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

Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!
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.....