Date Range

[qlikview979]

Hi Experts,

please find the my attached Excel file.

I have one Excel  sheet one having DATE field  dates from Jan1 to Jan30 and Sheet2 having TWo  fields STARTDATE and ENDDATE.

STARTDATE  ENDDATE

Jan5               Jan20 

i want now dates from sheet1 Jan5 to Jan20

Expected Output:-

Jan5

-

-

-

-

-

-

Jan20

[Gysbert_Wassenaar]

Please don't clutter this site with duplicate discussions: Date

[zhadrakas]

Hello Mahesh,

this should work

DateRange:
LOAD StartDate,
EndDate
FROM

(ooxml, embedded labels, table is Sheet2);

LET varMinDate = num(Peek('StartDate',-1,'DateRange'));
LET varMaxDate = num(Peek('EndDate',-1,'DateRange'));

drop table DateRange;

Calender:
LOAD
num($(varMinDate)+rowno()-1) AS DateNumber,
date($(varMinDate)+ rowno() -1, 'MMMDD') AS TempDate
AUTOGENERATE
$(varMaxDate)-$(varMinDate)+1;

[settu_periasamy · Accepted solution]

Check Here ..Date

[qlikview979]

Hi Tim Driller,

thanks for support,i got the output.

Regards,
Mahesh.