https://community.qlik.com/t5/QlikView/Latest-date-with-data-in-other-field/m-p/1701173#M455636 <P>Hi all, I'm trying to show in as a KPI chart the latest date in which other field has data greater than zero.</P><P>This is what I have:</P><P>&nbsp;</P><TABLE width="257"><TBODY><TR><TD width="80">date</TD><TD width="177">things</TD></TR><TR><TD>nov-19</TD><TD>3</TD></TR><TR><TD>dec-19</TD><TD>8</TD></TR><TR><TD>jan-20</TD><TD>13</TD></TR><TR><TD>feb-20</TD><TD>24</TD></TR><TR><TD>mar-20</TD><TD>36</TD></TR><TR><TD>apr-20</TD><TD>0</TD></TR><TR><TD>may-20</TD><TD>0</TD></TR><TR><TD>jun-20</TD><TD>0</TD></TR><TR><TD>jul-20</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In this example I'd need to show "mar-20" , which is the latest date where "things" has a value greater than zero.</P><P>&nbsp;</P><P>Any ideas? I've tried to no avail:</P><P>Max(if ([things] = 0, date))</P><P>&nbsp;</P><P>Thanks in advance.</P> Tue, 12 May 2020 15:12:25 GMT gbernabo 2020-05-12T15:12:25Z https://community.qlik.com/t5/QlikView/Latest-date-with-data-in-other-field/m-p/1701173#M455636 <P>Hi all, I'm trying to show in as a KPI chart the latest date in which other field has data greater than zero.</P><P>This is what I have:</P><P>&nbsp;</P><TABLE width="257"><TBODY><TR><TD width="80">date</TD><TD width="177">things</TD></TR><TR><TD>nov-19</TD><TD>3</TD></TR><TR><TD>dec-19</TD><TD>8</TD></TR><TR><TD>jan-20</TD><TD>13</TD></TR><TR><TD>feb-20</TD><TD>24</TD></TR><TR><TD>mar-20</TD><TD>36</TD></TR><TR><TD>apr-20</TD><TD>0</TD></TR><TR><TD>may-20</TD><TD>0</TD></TR><TR><TD>jun-20</TD><TD>0</TD></TR><TR><TD>jul-20</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In this example I'd need to show "mar-20" , which is the latest date where "things" has a value greater than zero.</P><P>&nbsp;</P><P>Any ideas? I've tried to no avail:</P><P>Max(if ([things] = 0, date))</P><P>&nbsp;</P><P>Thanks in advance.</P> Tue, 12 May 2020 15:12:25 GMT https://community.qlik.com/t5/QlikView/Latest-date-with-data-in-other-field/m-p/1701173#M455636 gbernabo 2020-05-12T15:12:25Z https://community.qlik.com/t5/QlikView/Latest-date-with-data-in-other-field/m-p/1701217#M455637 <P>Try this in KPI object.</P><P>=Date(FirstSortedValue(date,things*-1))</P><P>&nbsp;</P><P>Make sure the "date" field is a proper Date field, meaning it is not a text value.</P><P>&nbsp;</P> Tue, 12 May 2020 17:04:34 GMT https://community.qlik.com/t5/QlikView/Latest-date-with-data-in-other-field/m-p/1701217#M455637 kaushiknsolanki 2020-05-12T17:04:34Z https://community.qlik.com/t5/QlikView/Latest-date-with-data-in-other-field/m-p/1701219#M455638 <P>Thanks, that worked!</P><P>&nbsp;</P><P>IDK why, but&nbsp;<SPAN>Max(if ([things] &gt; 0, date)) also works..</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 12 May 2020 17:44:32 GMT https://community.qlik.com/t5/QlikView/Latest-date-with-data-in-other-field/m-p/1701219#M455638 gbernabo 2020-05-12T17:44:32Z