Interval Match

[QlikAngel]

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

[Chanty4u]

samples

Interval Match.xlsx

Interval Match Feature/Function

[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 · Accepted solution]

Hi

PFA

Refer this to learn about intervalmatch.

IntervalMatch