Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculate prevous date in script side.

Hi All,

I want to calculate previous date for that workcenter for that functional location in script side and if no date then it should be blank.

I have attached sample file for that, in that Output column is my expected ooutput Administrator

1 Reply
anbu1984
Master III
Master III

Load *,If(RowNo() > 1 And Previous([Work Center]) = [Work Center],Previous(Date)) As Output1;

LOAD [Work Center],

     [Functional Location],

     Date,

     Output

FROM

C:\Users\Rajesh.Rayapati\Desktop\Sample.xlsx

(ooxml, embedded labels, table is Sheet1);