Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Refer this to learn about intervalmatch.
Interval Match Feature/Function
check the attached PDF and the QVW it will help you understand the interval match function
Do you want to create new rows having new date field along with existing data having values from FROM DATE to TO DATE?
try to generate the Dates like below
Load * ,
date(estimation_from_date +iterno()-1) as EstimationDateFrom Table
while estimation_from_date +iterno()-1 <= estimation_to_date ;