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: 
leivers1
Contributor II
Contributor II

Apply calculated field value to all rows with that id

Hi,

I am calculating a new date field based on the status  in the load script like so 

if(newstatus = 'In Review', Date(Date(transitiondate,'YYYY-MM-DD hh:mm:ss.f'))) as inreviewdate

 

However obviously this date field is only showing up for the row with that status (See picture).

How can I apply this date to all rows associated with that issue key so that i can fulfil  a calculation for the 3rd row (in first table below), where I am subtracting  the dates that and item went into review (inreviewdate) and when it was resolved .

 

08-03-2019 5-17-27 PM.png

 

 

 

 

Labels (3)
1 Reply
bing_jville
Contributor III
Contributor III

In the second table, change num(inreviewdate) to num(transitiondate)