topic Exp in QlikView https://community.qlik.com/t5/QlikView/Exp/m-p/1435276#M818319 <HTML><HEAD></HEAD><BODY><P>The last run date column should show the last dae for checkin icrm as 25-06-2017 it is considering the all ...</P><P>How do i handel this ...Can someon suggeust how to write the formula for this </P><P></P><P></P><P>PLease find the attachment of the QVW file </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z Exp https://community.qlik.com/t5/QlikView/Exp/m-p/1435276#M818319 <HTML><HEAD></HEAD><BODY><P>The last run date column should show the last dae for checkin icrm as 25-06-2017 it is considering the all ...</P><P>How do i handel this ...Can someon suggeust how to write the formula for this </P><P></P><P></P><P>PLease find the attachment of the QVW file </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exp/m-p/1435276#M818319 smilingjohn 2020-11-25T16:16:04Z Re: Exp https://community.qlik.com/t5/QlikView/Exp/m-p/1435277#M818320 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Aggr(If(max(TOTAL &lt;Almrun_masterGroup, Almrun_masterComponent&gt; RunDate) = RunDate, RunDate),Almrun_masterGroup, Almrun_masterComponent, RunDate)</STRONG></P></BODY></HTML> Mon, 21 Aug 2017 11:38:33 GMT https://community.qlik.com/t5/QlikView/Exp/m-p/1435277#M818320 sunny_talwar 2017-08-21T11:38:33Z