topic Re: Max and Min date in QlikView https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105373#M16579 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>More complicated, if I want to find the average, that is, the sum of the column "%" on count (Producto). In the example it would be: 260.09 / 13 = 20.01.</P><P></P><P>Regards.</P></BODY></HTML> Tue, 21 Aug 2018 21:54:47 GMT spividori 2018-08-21T21:54:47Z Max and Min date https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105370#M16576 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>In my application I need to calculate the variation between the first and last Price for each product entered in the selected period.</P><P>Attached file example, in which when I select a product works perfect but when it is more than one product, it does not work.</P><P>Regards.</P></BODY></HTML> Tue, 21 Aug 2018 14:14:30 GMT https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105370#M16576 spividori 2018-08-21T14:14:30Z Re: Max and Min date https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105371#M16577 <HTML><HEAD></HEAD><BODY><P>Try with firstSortedValue() function</P><P></P><P><STRONG style="font-size: 10pt;">FirstSortedValue(Aggr(Sum(Precio), NumFecha, Producto), Aggr(NumFecha, NumFecha, Producto))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>FirstSortedValue(Aggr(Sum(Precio), NumFecha, Producto), -Aggr(NumFecha, NumFecha, Producto))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>FirstSortedValue(Aggr(Sum(Precio), NumFecha, Producto), -Aggr(NumFecha, NumFecha, Producto))/FirstSortedValue(Aggr(Sum(Precio), NumFecha, Producto), Aggr(NumFecha, NumFecha, Producto))-1</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/211410_Capture.PNG" style="height: 259px; width: 620px;" /></P></BODY></HTML> Tue, 21 Aug 2018 14:20:59 GMT https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105371#M16577 sunny_talwar 2018-08-21T14:20:59Z Re: Max and Min date https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105372#M16578 <HTML><HEAD></HEAD><BODY><P>It works perfectly. Thanks.</P><P></P><P>Regards.</P></BODY></HTML> Tue, 21 Aug 2018 14:39:01 GMT https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105372#M16578 spividori 2018-08-21T14:39:01Z Re: Max and Min date https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105373#M16579 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>More complicated, if I want to find the average, that is, the sum of the column "%" on count (Producto). In the example it would be: 260.09 / 13 = 20.01.</P><P></P><P>Regards.</P></BODY></HTML> Tue, 21 Aug 2018 21:54:47 GMT https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105373#M16579 spividori 2018-08-21T21:54:47Z Re: Max and Min date https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105374#M16580 <HTML><HEAD></HEAD><BODY><P>Not entirely sure I follow</P></BODY></HTML> Wed, 22 Aug 2018 11:01:03 GMT https://community.qlik.com/t5/QlikView/Max-and-Min-date/m-p/105374#M16580 sunny_talwar 2018-08-22T11:01:03Z