Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikAngel
Partner - Creator
Partner - Creator

Interval Match

Hi,

please find the attched file of data...

estimation from date & estimation to date .. field needs one date field.. where date fields like.. 1st, 2nd, 3rd  etc date should be there..

i know this will work with interval match but how to use.

please suggest

1 Solution

Accepted Solutions
MayilVahanan

Hi

PFA

Refer this to learn about intervalmatch.

IntervalMatch

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

5 Replies
avinashelite

check the attached PDF and the QVW it will help you understand the interval match function

Digvijay_Singh

Do you want to create new rows having new date field along with existing data having values from FROM DATE to TO DATE?

Kushal_Chawda

try to generate the Dates like below

Data:

Load * ,

        date(estimation_from_date +iterno()-1) as EstimationDate
From Table

while estimation_from_date +iterno()-1 <= estimation_to_date ;

MayilVahanan

Hi

PFA

Refer this to learn about intervalmatch.

IntervalMatch

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.