Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

interval match and peek

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.

3 Replies
vinay_bangari
Valued Contributor III

Re: interval match and peek

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 ;

Not applicable

Re: interval match and peek

right answer

vinay_bangari
Valued Contributor III

Re: interval match and peek

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

Community Browser