topic Re: Need help with one to many table in QlikView

Need help with one to many table

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Need help with one to many table

Anil_Babu_Samineni — Wed, 18 Oct 2017 09:17:34 GMT

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

Re: Need help with one to many table

Wed, 18 Oct 2017 09:20:17 GMT

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

Re: Need help with one to many table

effinty2112 — Wed, 18 Oct 2017 09:26:21 GMT

Hi Baris,

Try:

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

Regards

Andrew

Re: Need help with one to many table

Wed, 18 Oct 2017 10:50:16 GMT

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