topic Re: Show date with the highest Amount in QlikView https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005546#M341572 <HTML><HEAD></HEAD><BODY><P>Here is a sample by <A href="https://community.qlik.com/qlik-users/20401">samuel</A>‌</P></BODY></HTML> Tue, 06 Oct 2015 11:35:19 GMT sujeetsingh 2015-10-06T11:35:19Z Show date with the highest Amount https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005542#M341568 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en">How I can display the date with the highest amount of a month?</SPAN></P><P></P><P><SPAN style="color: #ff8000; font-size: 8pt; text-decoration: underline;"><STRONG>(</STRONG></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">ExisteTiquet</SPAN><SPAN style="font-size: 8pt;">={'Si'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">Año</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=Max(Año))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Amount</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Mes</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Posting Date]</SPAN><SPAN style="font-size: 8pt;">))</SPAN><STRONG style=": ; color: #ff8000; font-size: 8pt; text-decoration: underline;">) </STRONG></P><P><SPAN lang="en"></SPAN></P><P></P><P><SPAN lang="en"><SPAN lang="en">This function gives me the amount . But what date?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en">Thanks in advence</SPAN></SPAN></P></BODY></HTML> Tue, 06 Oct 2015 11:30:22 GMT https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005542#M341568 2015-10-06T11:30:22Z Re: Show date with the highest Amount https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005543#M341569 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue([Posting Date], <SPAN style="color: #ff8000; font-size: 10.6667px;"><STRONG style="text-decoration: underline;">-</STRONG></SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">aggr</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">({&lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">ExisteTiquet</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">={'Si'},</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Año</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">={</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 8pt; font-family: inherit; color: #808080;">$(=Max(Año))</EM></STRONG><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">}&gt;}</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Amount</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">),</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Mes</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">,</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[Posting Date]</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">))</SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN>Check number of brackets at the end...</P></BODY></HTML> Tue, 06 Oct 2015 11:32:19 GMT https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005543#M341569 MK_QSL 2015-10-06T11:32:19Z Re: Show date with the highest Amount https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005544#M341570 <HTML><HEAD></HEAD><BODY><P>Hi Paco</P><P></P><P>Is it possible to get some sample date/qvw?</P><P></P><P>/Teis</P></BODY></HTML> Tue, 06 Oct 2015 11:32:24 GMT https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005544#M341570 teiswamsler 2015-10-06T11:32:24Z Re: Show date with the highest Amount https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005545#M341571 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Very good</SPAN> Thanks</P></BODY></HTML> Tue, 06 Oct 2015 11:34:24 GMT https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005545#M341571 2015-10-06T11:34:24Z Re: Show date with the highest Amount https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005546#M341572 <HTML><HEAD></HEAD><BODY><P>Here is a sample by <A href="https://community.qlik.com/qlik-users/20401">samuel</A>‌</P></BODY></HTML> Tue, 06 Oct 2015 11:35:19 GMT https://community.qlik.com/t5/QlikView/Show-date-with-the-highest-Amount/m-p/1005546#M341572 sujeetsingh 2015-10-06T11:35:19Z