Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qlikview979
Valued Contributor

Date Range

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

1 Solution

Accepted Solutions

Re: Date Range

Check Here ..Date

4 Replies
MVP & Luminary
MVP & Luminary

Re: Date Range

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


talk is cheap, supply exceeds demand
zhadrakas
Valued Contributor

Re: Date Range

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

Check Here ..Date

qlikview979
Valued Contributor

Re: Date Range

Hi Tim Driller,

thanks for support,i got the output.

Regards,
Mahesh.