Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

AGGR???

Hello everyone:

I need help with the following. I have the following table:

Base de Datos.jpg

Patent = Automobiles.

Date = Fuel charge date.

Branch = Place to which the car belongs.

The branch can change with the passage of time as for example can be seen in the patent AAA111.

The yellow rows are the ones you should select for the result (Correct rows).

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.

The rest should be:

Resultado.jpg

I attached the excel table complete with the result.

From already thank you very much for the help.

1 Solution

Accepted Solutions
felipedl
Partner
Partner

Hi Martin,

Attached one solution, using joins with a flag on the max date for each field "Patente".

Hope it helps

Regards,

Felipe.

View solution in original post

4 Replies
felipedl
Partner
Partner

Hi Martin,

Attached one solution, using joins with a flag on the max date for each field "Patente".

Hope it helps

Regards,

Felipe.

View solution in original post

Not applicable
Author

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.

Muchas gracias!!! Excelente!

felipedl
Partner
Partner

Hi,

Didnt' see there was a excel file with the data you needed.

Attached is a QVW using the provided data.

Glad i'd helped

Not applicable
Author

USTED ES DIOS !!!!

Muchas muchas muchas gracias!!!!