topic Re: AGGR??? in QlikView https://community.qlik.com/t5/QlikView/AGGR/m-p/1354865#M415937 <HTML><HEAD></HEAD><BODY><P><SPAN><SPAN>USTED ES DIOS !!!!</SPAN></SPAN></P><P></P><P>Muchas muchas muchas gracias!!!!</P></BODY></HTML> Mon, 29 May 2017 19:50:40 GMT 2017-05-29T19:50:40Z AGGR??? https://community.qlik.com/t5/QlikView/AGGR/m-p/1354861#M415933 <HTML><HEAD></HEAD><BODY><P>Hello everyone:</P><P></P><P>I need help with the following. I have the following table:</P><P></P><P><IMG alt="Base de Datos.jpg" class="jive-image image-1" src="/legacyfs/online/165125_Base de Datos.jpg" style="height: auto;" /></P><P>Patent = Automobiles.</P><P>Date = Fuel charge date.</P><P>Branch = Place to which the car belongs.</P><P></P><P>The branch can change with the passage of time as for example can be seen in the patent AAA111.</P><P></P><P>The yellow rows are the ones you should select for the result (Correct rows).</P><P></P><P>I need to build a list where by branch I calculate the number of patents that are per branch ONLY taking into account the last charge of gasoline.</P><P></P><P>The rest should be:</P><P></P><P><IMG alt="Resultado.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/165126_Resultado.jpg" style="height: auto;" /></P><P>I attached the excel table complete with the result.</P><P></P><P></P><P>From already thank you very much for the help.</P></BODY></HTML> Mon, 29 May 2017 17:10:10 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/1354861#M415933 2017-05-29T17:10:10Z Re: AGGR??? https://community.qlik.com/t5/QlikView/AGGR/m-p/1354862#M415934 <HTML><HEAD></HEAD><BODY><P>Hi Martin,</P><P></P><P>Attached one solution, using joins with a flag on the max date for each field "Patente".</P><P>Hope it helps</P><P></P><P>Regards,</P><P></P><P>Felipe.</P></BODY></HTML> Mon, 29 May 2017 18:52:29 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/1354862#M415934 felipedl 2017-05-29T18:52:29Z Re: AGGR??? https://community.qlik.com/t5/QlikView/AGGR/m-p/1354863#M415935 <HTML><HEAD></HEAD><BODY><P>Muy bueno!!! Se acerca mucho a lo que estoy necesitando. Voy a mirar si puedo adaptar el ejemplo al tablero que estoy armando y te comunico.</P><P></P><P>Muchas gracias!!! Excelente!</P></BODY></HTML> Mon, 29 May 2017 19:15:28 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/1354863#M415935 2017-05-29T19:15:28Z Re: AGGR??? https://community.qlik.com/t5/QlikView/AGGR/m-p/1354864#M415936 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Didnt' see there was a excel file with the data you needed.</P><P></P><P>Attached is a QVW using the provided data.</P><P></P><P>Glad i'd helped <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 May 2017 19:24:40 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/1354864#M415936 felipedl 2017-05-29T19:24:40Z Re: AGGR??? https://community.qlik.com/t5/QlikView/AGGR/m-p/1354865#M415937 <HTML><HEAD></HEAD><BODY><P><SPAN><SPAN>USTED ES DIOS !!!!</SPAN></SPAN></P><P></P><P>Muchas muchas muchas gracias!!!!</P></BODY></HTML> Mon, 29 May 2017 19:50:40 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/1354865#M415937 2017-05-29T19:50:40Z