Discussion Board for collaboration related to QlikView App Development.
I need help with the following. I have the following table:
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:
I attached the excel table complete with the result.
From already thank you very much for the help.
Attached one solution, using joins with a flag on the max date for each field "Patente".
Hope it helps
View solution in original post
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!
Didnt' see there was a excel file with the data you needed.
Attached is a QVW using the provided data.
Glad i'd helped
USTED ES DIOS !!!!
Muchas muchas muchas gracias!!!!