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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get common month and year

i have Startdate and Enddate in a table....

my requirement is i need a single Date field  which is having both start and end date and also month field and year field

Output : Date  Month Year

How to do this?

2 Replies
sunny_talwar

You can use While Loop to create missing dates

Loops in the Script

or you can use interval match

IntervalMatch

rido1421
Creator III
Creator III

Hi Sanju

I believe you will need to use interval match, read up on the below.

IntervalMatch

Regards,