Date

[qlikview979]

Hi Experts,

I have one Excel file Sheet1 having  one column  date like JAN1 to  JAN30 and sheet having "Startdate" and "Enddate" fields.

if i give  in sheet 2 like

Startdate  Enddate

JAN5        JAN20

i want here date from JAN5 to JAN20

Expected output:-

jan5

-

-

--

-

-

jan20

Regards,

Mahesh.

[qlikview979]

Hi,

Can any one give solution to my requirement.

[settu_periasamy]

Can you share you excel and expected output?

may be like this?

T1:
LOAD * INLINE [
StartDate, EndDate
1/1/2016, 1/31/2016
2/1/2016, 2/10/2016
];

NoConcatenate
T2:
LOAD Date(StartDate+IterNo()-1) as Date
Resident T1 While Date(StartDate+IterNo()-1)<=EndDate;

DROP Table T1;

[qlikview979]

Hi,

I am using this script but my where condition is not working.

T1:

LOAD StartDate,

     EndDate

FROM

(ooxml, embedded labels, table is Sheet2);

let vpeek=Peek('StartDate',0,'T1');

let vpeek1=Peek('EndDate',0,'T1');

DROP table T1;

T2:

LOAD Date

FROM

(ooxml, embedded labels, table is Sheet1)

Where $(vpeek)>=Date and  $(vpeek1)>=Date;

[settu_periasamy]

Did you check the vpeek and vpeek1 format? is that match your Date field?

Can you post the sample Excel file?

[qlikview979]

Hi,

Please find my Attachment.

[settu_periasamy · Accepted solution]

Try this..

T1:

LOAD StartDate,

     EndDate

FROM

[Date Range Excel.xlsx]

(ooxml, embedded labels, table is Sheet2);

let vpeek=Peek('StartDate',0,'T1');

let vpeek1=Peek('EndDate',0,'T1');

DROP table T1;

T2:

LOAD Date

FROM

[Date Range Excel.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Date>='$(vpeek)' and  Date<='$(vpeek1)';

[qlikview979]

Hi,

Thanks,Its Perfectly Working.

Regards,
mahesh

[settu_periasamy]

Welcome.

Can you close this thread, if you got the answer?

[jonathandienst]

Please close your threads once they have been answered. You have dozens of open questions and its good practice to close those that have been correctly answered.