topic Re: Dates in text object in QlikView https://community.qlik.com/t5/QlikView/Dates-in-text-object/m-p/1452132#M804824 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>'Renewal - &amp; Min({&lt;[Data Type] = {'Renewal'}&gt;} Date) &amp; ' -&nbsp; Cancellation - ' &amp; <SPAN style="font-size: 13.3333px;">Min({&lt;[Data Type] = {'<SPAN style="font-size: 13.3333px;">Cancellation</SPAN>'}&gt;} Date)</SPAN></P></BODY></HTML> Fri, 10 Nov 2017 16:08:21 GMT sunny_talwar 2017-11-10T16:08:21Z Dates in text object https://community.qlik.com/t5/QlikView/Dates-in-text-object/m-p/1452131#M804823 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have few dates as belwo</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Date Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Renewal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/10/2018</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cancellation&nbsp;&nbsp;&nbsp;&nbsp; 10/10/2020</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Cancellation&nbsp;&nbsp;&nbsp;&nbsp; 10/10/2018</SPAN></P><P></P><P>In Text object I want to show most recent date (min(Date)) on each date type.</P><P></P><P>Renewal - 11/10/2018 &amp;'-'&amp; Cancellation - 10/10/2018</P><P></P><P>Can this be done ?</P><P></P><P></P><P>Than you very much</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dates-in-text-object/m-p/1452131#M804823 apthansh 2020-11-25T16:16:04Z Re: Dates in text object https://community.qlik.com/t5/QlikView/Dates-in-text-object/m-p/1452132#M804824 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>'Renewal - &amp; Min({&lt;[Data Type] = {'Renewal'}&gt;} Date) &amp; ' -&nbsp; Cancellation - ' &amp; <SPAN style="font-size: 13.3333px;">Min({&lt;[Data Type] = {'<SPAN style="font-size: 13.3333px;">Cancellation</SPAN>'}&gt;} Date)</SPAN></P></BODY></HTML> Fri, 10 Nov 2017 16:08:21 GMT https://community.qlik.com/t5/QlikView/Dates-in-text-object/m-p/1452132#M804824 sunny_talwar 2017-11-10T16:08:21Z Re: Dates in text object https://community.qlik.com/t5/QlikView/Dates-in-text-object/m-p/1452133#M804825 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Concat</SPAN>(<SPAN style="color: #0000ff;">DISTINCT</SPAN> <SPAN style="color: #800000;">[Date Type]</SPAN>&amp;'-'&amp; <SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">NODISTINCT</SPAN> <SPAN style="color: #0000ff;">MinString</SPAN>(<SPAN style="color: #800000;">Date</SPAN>),<SPAN style="color: #800000;">[Date Type]</SPAN>),<SPAN style="color: #0000ff;">Chr</SPAN></SPAN><SPAN style="font-size: 10pt;">(10)) </SPAN></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182872_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 10 Nov 2017 16:31:12 GMT https://community.qlik.com/t5/QlikView/Dates-in-text-object/m-p/1452133#M804825 antoniotiman 2017-11-10T16:31:12Z