topic Re: interval match and peek in Qlik Learning Discussions

interval match and peek

Tue, 10 Feb 2015 23:16:17 GMT

The client is a sewing machines institution. The client would like access dashboard to be able to analyze what is the end date and capability sewing machines are available at a particular day. To facilitate this client has provided records of recent database of sewing machine availability. Each database has information about hour’s sewing machine available, workspace, start date and end date.

Here is the respective data, workspace AA is allocated for 100 minutes from 1/1/2014 to 1/12/2014 and 200 minutes from 1/14/2014 to 1/24/2014. Workspace BB is allocated for 100 minutes from 1/8/2014 to 1/17/2014 and 200 minutes from 1/19/2014 to 1/24/2014.

Re: interval match and peek

Anonymous — Wed, 11 Feb 2015 14:36:38 GMT

Final:

LOAD [Work center],

Date

FROM

(ooxml, embedded labels, table is Sheet1);

Temp_Capacity:

LOAD [Work center],

[Start date],

capacity

FROM

(ooxml, embedded labels, table is Sheet2);

Cap2:

LOAD

[Start date],

if(len(Peek([Start date]))=0 or [Work center]<>peek([Work center]),'1/1/2020',date(peek([Start date])-1)) as End_date,

[Work center],

capacity

Resident Temp_Capacity

order by [Work center], [Start date] desc;

drop table Temp_Capacity;

left join (Final)

IntervalMatch(Date,[Work center])

LOAD

[Start date],

End_date,

[Work center]

Resident Cap2 ;

Re: interval match and peek

Wed, 11 Feb 2015 19:06:41 GMT

right answer

Re: interval match and peek

Anonymous — Wed, 11 Feb 2015 19:08:19 GMT

suma its not like that there will be a button which says correct answer below my reply .