topic Repeat max Date for Same ID in QlikView https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206025#M880761 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have this Requirement</P><P></P><P><IMG alt="max Repeat.png" class="jive-image image-1" src="/legacyfs/online/139919_max Repeat.png" style="height: 101px; width: 620px;" /></P><P></P><P>For Better understanding, I have Attached sample qvw.</P><P></P><P>Regards</P><P>Cire</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Repeat max Date for Same ID https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206025#M880761 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have this Requirement</P><P></P><P><IMG alt="max Repeat.png" class="jive-image image-1" src="/legacyfs/online/139919_max Repeat.png" style="height: 101px; width: 620px;" /></P><P></P><P>For Better understanding, I have Attached sample qvw.</P><P></P><P>Regards</P><P>Cire</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206025#M880761 2020-11-25T16:16:04Z Re: Repeat max Date for Same ID https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206026#M880762 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=If(Year(Date1)=1900,FirstSortedValue(Total&lt;ID&gt; Date2, -Flag),Date1)</P></BODY></HTML> Thu, 06 Oct 2016 21:07:24 GMT https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206026#M880762 swuehl 2016-10-06T21:07:24Z Re: Repeat max Date for Same ID https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206027#M880763 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P><STRONG>IF(WildMatch(Date1,'*1900*'),FirstSortedValue(TOTAL &lt;ID&gt; Date2, -Flag),Date1)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139920_Capture.PNG" style="height: 85px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Thu, 06 Oct 2016 21:09:19 GMT https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206027#M880763 sunny_talwar 2016-10-06T21:09:19Z Re: Repeat max Date for Same ID https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206028#M880764 <HTML><HEAD></HEAD><BODY><P>Thank You Both of You.</P><P>Great Learning for me.</P><P></P><P>Regards</P><P>Cire</P></BODY></HTML> Fri, 07 Oct 2016 19:18:17 GMT https://community.qlik.com/t5/QlikView/Repeat-max-Date-for-Same-ID/m-p/1206028#M880764 2016-10-07T19:18:17Z