Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mayuridg
Contributor

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

Re: Interval Match

Hi

PFA

Refer this to learn about intervalmatch.

IntervalMatch

5 Replies
sureshqv
Esteemed Contributor III

Re: Interval Match

Re: Interval Match

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

Digvijay_Singh
Honored Contributor III

Re: Interval Match

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

Re: Interval Match

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 ;

Re: Interval Match

Hi

PFA

Refer this to learn about intervalmatch.

IntervalMatch

Community Browser