https://community.qlik.com/t5/App-Development/Apply-calculated-field-value-to-all-rows-with-that-id/m-p/1554606#M39974 <P>In the second table, change num(inreviewdate) to num(<SPAN>transitiondate</SPAN>)</P> Sun, 10 Mar 2019 17:48:23 GMT bing_jville 2019-03-10T17:48:23Z https://community.qlik.com/t5/App-Development/Apply-calculated-field-value-to-all-rows-with-that-id/m-p/1554383#M39924 <P>Hi,</P><P>I am calculating a new date field based on the status&nbsp; in the load script like so&nbsp;</P><P>if(newstatus = 'In Review', Date(Date(transitiondate,'YYYY-MM-DD hh:mm:ss.f'))) as inreviewdate</P><P>&nbsp;</P><P>However obviously this date field is only showing up for the row with that status (See picture).</P><P>How can I apply this date to all rows associated with that issue key so that i can fulfil&nbsp; a calculation for the 3rd row (in first table below), where I am subtracting&nbsp; the dates that and item went into review (inreviewdate) and when it was resolved .</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="08-03-2019 5-17-27 PM.png" style="width: 734px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7626iEC32D5BAE5D29202/image-size/large?v=v2&amp;px=999" role="button" title="08-03-2019 5-17-27 PM.png" alt="08-03-2019 5-17-27 PM.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 06:23:00 GMT https://community.qlik.com/t5/App-Development/Apply-calculated-field-value-to-all-rows-with-that-id/m-p/1554383#M39924 leivers1 2024-11-16T06:23:00Z https://community.qlik.com/t5/App-Development/Apply-calculated-field-value-to-all-rows-with-that-id/m-p/1554606#M39974 <P>In the second table, change num(inreviewdate) to num(<SPAN>transitiondate</SPAN>)</P> Sun, 10 Mar 2019 17:48:23 GMT https://community.qlik.com/t5/App-Development/Apply-calculated-field-value-to-all-rows-with-that-id/m-p/1554606#M39974 bing_jville 2019-03-10T17:48:23Z