Discussion board where members can get started with QlikView.
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.
i want now dates from sheet1 Jan5 to Jan20
Go to Solution.
Check Here ..Date
Please don't clutter this site with duplicate discussions: Date
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;
Hi Tim Driller,
thanks for support,i got the output.