https://community.qlik.com/t5/App-Development/calculate-an-input-value-that-is-between-the-latest-date/m-p/2471114#M99686 <P>I have Field&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1721204796093.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169456i00C17344BE3B0354/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1721204796093.png" alt="Sxbbb_0-1721204796093.png" /></span></P> <P>I want to calculate an input value that is between the latest date of Date_Start_FX and the latest date of KCE_DATE.</P> <P>&nbsp;</P> <P>I try&nbsp; Sum(Aggr(if(KCE_DATE &gt;= Date(Max(Aggr(Max(Date_Start), FX_FixtureID))),<BR />Sum(if ((INPUT ) &gt;0 ,INPUT , [INTERNAL_REWORK])),0),FX_FixtureID))&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1721205058680.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169457i86AF670453CB7666/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1721205058680.png" alt="Sxbbb_1-1721205058680.png" /></span></P> <P>I want to calculate an input value that is between the latest date of Date_Start_FX and the latest date of KCE_DATE.</P> Fri, 15 Nov 2024 20:54:43 GMT Sxbbb 2024-11-15T20:54:43Z https://community.qlik.com/t5/App-Development/calculate-an-input-value-that-is-between-the-latest-date/m-p/2471114#M99686 <P>I have Field&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1721204796093.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169456i00C17344BE3B0354/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1721204796093.png" alt="Sxbbb_0-1721204796093.png" /></span></P> <P>I want to calculate an input value that is between the latest date of Date_Start_FX and the latest date of KCE_DATE.</P> <P>&nbsp;</P> <P>I try&nbsp; Sum(Aggr(if(KCE_DATE &gt;= Date(Max(Aggr(Max(Date_Start), FX_FixtureID))),<BR />Sum(if ((INPUT ) &gt;0 ,INPUT , [INTERNAL_REWORK])),0),FX_FixtureID))&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1721205058680.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169457i86AF670453CB7666/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1721205058680.png" alt="Sxbbb_1-1721205058680.png" /></span></P> <P>I want to calculate an input value that is between the latest date of Date_Start_FX and the latest date of KCE_DATE.</P> Fri, 15 Nov 2024 20:54:43 GMT https://community.qlik.com/t5/App-Development/calculate-an-input-value-that-is-between-the-latest-date/m-p/2471114#M99686 Sxbbb 2024-11-15T20:54:43Z https://community.qlik.com/t5/App-Development/calculate-an-input-value-that-is-between-the-latest-date/m-p/2471120#M99688 <P><A href="https://community.qlik.com/t5/New-to-Qlik-Analytics/select-the-correct-fields-and-values-Don-t-select-a-field/m-p/2470478#M253597" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Analytics/select-the-correct-fields-and-values-Don-t-select-a-field/m-p/2470478#M253597</A>&nbsp; &nbsp;More details</P> Wed, 17 Jul 2024 08:49:57 GMT https://community.qlik.com/t5/App-Development/calculate-an-input-value-that-is-between-the-latest-date/m-p/2471120#M99688 Sxbbb 2024-07-17T08:49:57Z