topic Re: Date Range in QlikView

Date Range

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date Range

Gysbert_Wassenaar — Fri, 06 May 2016 05:39:31 GMT

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

Re: Date Range

zhadrakas — Fri, 06 May 2016 05:41:13 GMT

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;

Re: Date Range

settu_periasamy — Fri, 06 May 2016 05:48:48 GMT

Check Here ..Date

Re: Date Range

qlikview979 — Sat, 07 May 2016 05:01:30 GMT

Hi Tim Driller,

thanks for support,i got the output.

Regards,
Mahesh.