https://community.qlik.com/t5/App-Development/KPI-Default-Selection/m-p/1542614#M62744 Hi,<BR />Try this.<BR /><BR />Sum({&lt;[Category] = {'Direction'}, [Date] = {'$(=Max(Date))'}&gt;} [Value]) Tue, 12 Feb 2019 03:48:11 GMT ryo_okabe 2019-02-12T03:48:11Z https://community.qlik.com/t5/App-Development/KPI-Default-Selection/m-p/1542584#M62743 <P>I need to adjust the expression for my KPI, which is currently:</P><P>Sum({&lt;[Category] = {'Direction'}, [Date] = {'3/1/2018'}&gt;} [Value])</P><P>I hard-coded the date in the expression, but that's not what I want.&nbsp; What I want is the following:</P><P>If a selection is not applied, I want the default selection to be the max Date.&nbsp; However, if a Date selection is applied, then I want that to show on the KPI.</P><P>The data set is attached.&nbsp;&nbsp;</P><P>Thanks!</P> Fri, 02 Apr 2021 07:47:14 GMT https://community.qlik.com/t5/App-Development/KPI-Default-Selection/m-p/1542584#M62743 ltc 2021-04-02T07:47:14Z https://community.qlik.com/t5/App-Development/KPI-Default-Selection/m-p/1542614#M62744 Hi,<BR />Try this.<BR /><BR />Sum({&lt;[Category] = {'Direction'}, [Date] = {'$(=Max(Date))'}&gt;} [Value]) Tue, 12 Feb 2019 03:48:11 GMT https://community.qlik.com/t5/App-Development/KPI-Default-Selection/m-p/1542614#M62744 ryo_okabe 2019-02-12T03:48:11Z