topic Re: Help with dates? in QlikView

Help with dates?

qlikuser222 — Tue, 17 Oct 2017 19:20:28 GMT

Hi All,

i have a requirement where i need to calculate the fields based on the date (for example Payment Date) which falls between two dates (for example start and end date).

PFA attached files for sample data.

Thanks

Re: Help with dates?

MarcoARaymundo — Tue, 17 Oct 2017 21:11:17 GMT

in this case tray create a flag in load time..

if([Payment Date] >= StartDt and [Payment Date] <= EndDt, 1, 0) as Flag

Re: Help with dates?

maxgro — Tue, 17 Oct 2017 21:34:11 GMT

LOAD

[Payment Date] >= StartDt and [Payment Date] <= EndDt as Flag

;

LOAD ID,

date(date#([Payment Date], 'YYYYMMDD')) as [Payment Date],

StartDt,

EndDt

FROM

[test.xls] (biff, embedded labels, table is Sheet1$);