topic Re: Interval Match in QlikView

Interval Match

QlikAngel — Mon, 14 Mar 2016 06:34:18 GMT

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 — Mon, 14 Mar 2016 06:35:33 GMT

samples

avinashelite — Mon, 14 Mar 2016 06:39:03 GMT

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

Digvijay_Singh — Mon, 14 Mar 2016 06:40:00 GMT

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 — Mon, 14 Mar 2016 06:41:15 GMT

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 — Mon, 14 Mar 2016 06:48:21 GMT

PFA

Refer this to learn about intervalmatch.