Need help with one to many table

[#1]

Hello

I'm a newbie and I need some instructions on how to handle the tables below:

TableA

VehicleID	DocID	VIN
1	1	abc
2	2	def
3	3	ghi

Table B

VehicleID	DocID	Name	Date
1	1	checkinDoc	01/02/2017
1	2	checkoutDoc	02/02/2017

So if I filter out VehicleID 1 from Table A, how can I show the CheckinDoc - Date column in Qlik?

Edit1:

Also there are vehicles on Table B that have several checkinDoc for the same DocID for example as below:

VehicleID	DocID	Name	Date
1	1	checkinDoc
1	2	checkoutDoc
1	3	checkinDoc	01/02/2017
1	4	checkoutDoc	02/02/2017

On these occasions, I want to show of course only the values that have Date filled out for checkinDoc and chackoutDoc.

Meddelandet redigerades av: BT

[Anil_Babu_Samineni]

May be change second table filed called VehicleDocID to VehicleID and then try with filter in UI using Max(Date) in text object

Update - Attached

[#3]

Well - it's not Always the MAX(Date) I need from that table, and it's a much longer table than this of course.

[effinty2112]

Hi Baris,

Try:

only({$<Name = {'checkinDoc'}>}Date)

Regards

Andrew

[#5]

Hi Andrew

I put this on the Expression Formula, but it seems it takes only the first date that it finds - it's the same date on all the vehicles that is filtered. :S