topic Set Analysis with Aggr Challenge! in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggr-Challenge/m-p/43935#M787979 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>I had a problema with an aggr function. I need this 2 records in a table. If you see i need the Max FechaPrediccion_n for the Max FechaDeteccion</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193715_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>The problema is that when i put the Set Analysis it tooks just the max FechaDeteccion for both records <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P>It Works just for 1 record.</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/193716_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P><P>I need this Table</P><P>Codigo | Fecha Detección | Fecha Predicción_n | Días Predicción</P><P>R1100&nbsp;&nbsp;&nbsp; 14/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.6</P><P>R796&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.46</P><P></P><P></P><P>Hope you can help me :9</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT slondono 2020-11-25T16:16:04Z Set Analysis with Aggr Challenge! https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggr-Challenge/m-p/43935#M787979 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>I had a problema with an aggr function. I need this 2 records in a table. If you see i need the Max FechaPrediccion_n for the Max FechaDeteccion</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193715_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>The problema is that when i put the Set Analysis it tooks just the max FechaDeteccion for both records <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P>It Works just for 1 record.</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/193716_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P><P>I need this Table</P><P>Codigo | Fecha Detección | Fecha Predicción_n | Días Predicción</P><P>R1100&nbsp;&nbsp;&nbsp; 14/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.6</P><P>R796&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18/10/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.46</P><P></P><P></P><P>Hope you can help me :9</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggr-Challenge/m-p/43935#M787979 slondono 2020-11-25T16:16:04Z