topic Aggr Expression in QlikView

topic Aggr Expression in QlikView https://community.qlik.com/t5/QlikView/Aggr-Expression/m-p/1868201#M1216438 <P>Hello,</P> <P>I have the following table.</P> <TABLE width="206"> <TBODY> <TR> <TD width="43">ITEM</TD> <TD width="61">SUPPLIER</TD> <TD width="62">DATE</TD> <TD width="40">PRICE</TD> </TR> <TR> <TD>101642</TD> <TD>47922</TD> <TD>22/01/2020</TD> <TD>5,4</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>02/07/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>27/10/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>05/11/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>18/11/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>28/11/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>22/01/2021</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>23/01/2021</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>46739</TD> <TD>16/06/2021</TD> <TD>5,05</TD> </TR> <TR> <TD>101642</TD> <TD>46739</TD> <TD>17/06/2021</TD> <TD>5,05</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>18/06/2021</TD> <TD>5,26</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>22/10/2021</TD> <TD>5,26</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>23/10/2021</TD> <TD>5,26</TD> </TR> </TBODY> </TABLE> <P> </P> <P>With which way i can have the following table. I try with the aggr expression but i haven't the correct results. </P> <TABLE width="364"> <TBODY> <TR> <TD width="43">ITEM</TD> <TD width="61">SUPPLIER</TD> <TD width="63">MIN DATE</TD> <TD width="65">MIN PRICE</TD> <TD width="64">MAX DATE</TD> <TD width="68">MAX PRICE</TD> </TR> <TR> <TD>101642</TD> <TD>46739</TD> <TD>16/06/2021</TD> <TD>5,05</TD> <TD>17/06/2021</TD> <TD>5,05</TD> </TR> <TR> <TD>101642</TD> <TD>47922</TD> <TD>22/01/2020</TD> <TD>5,4</TD> <TD>22/01/2020</TD> <TD>5,4</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>02/07/2020</TD> <TD>5,61</TD> <TD>23/10/2021</TD> <TD>5,26</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Can anyone help me ?</P> <P>Thank you in advanced.</P> <P> </P> Wed, 08 Dec 2021 16:04:29 GMT geogou1973 2021-12-08T16:04:29Z Aggr Expression https://community.qlik.com/t5/QlikView/Aggr-Expression/m-p/1868201#M1216438 <P>Hello,</P> <P>I have the following table.</P> <TABLE width="206"> <TBODY> <TR> <TD width="43">ITEM</TD> <TD width="61">SUPPLIER</TD> <TD width="62">DATE</TD> <TD width="40">PRICE</TD> </TR> <TR> <TD>101642</TD> <TD>47922</TD> <TD>22/01/2020</TD> <TD>5,4</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>02/07/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>27/10/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>05/11/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>18/11/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>28/11/2020</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>22/01/2021</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>23/01/2021</TD> <TD>5,61</TD> </TR> <TR> <TD>101642</TD> <TD>46739</TD> <TD>16/06/2021</TD> <TD>5,05</TD> </TR> <TR> <TD>101642</TD> <TD>46739</TD> <TD>17/06/2021</TD> <TD>5,05</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>18/06/2021</TD> <TD>5,26</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>22/10/2021</TD> <TD>5,26</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>23/10/2021</TD> <TD>5,26</TD> </TR> </TBODY> </TABLE> <P> </P> <P>With which way i can have the following table. I try with the aggr expression but i haven't the correct results. </P> <TABLE width="364"> <TBODY> <TR> <TD width="43">ITEM</TD> <TD width="61">SUPPLIER</TD> <TD width="63">MIN DATE</TD> <TD width="65">MIN PRICE</TD> <TD width="64">MAX DATE</TD> <TD width="68">MAX PRICE</TD> </TR> <TR> <TD>101642</TD> <TD>46739</TD> <TD>16/06/2021</TD> <TD>5,05</TD> <TD>17/06/2021</TD> <TD>5,05</TD> </TR> <TR> <TD>101642</TD> <TD>47922</TD> <TD>22/01/2020</TD> <TD>5,4</TD> <TD>22/01/2020</TD> <TD>5,4</TD> </TR> <TR> <TD>101642</TD> <TD>59368</TD> <TD>02/07/2020</TD> <TD>5,61</TD> <TD>23/10/2021</TD> <TD>5,26</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Can anyone help me ?</P> <P>Thank you in advanced.</P> <P> </P> Wed, 08 Dec 2021 16:04:29 GMT https://community.qlik.com/t5/QlikView/Aggr-Expression/m-p/1868201#M1216438 geogou1973 2021-12-08T16:04:29Z