Data from another table

[kavieweg]

Hi Guys,

when i create a table in qlik sense nothing is shown in Name because the Value from the order table is not disticnt. I would like to have the Name where the Timestamp is the newest one. Can anyone help?

Global Table
ID		Name		Status
ABCDE		-		900
Order Table
Kee	ID	Name	Timestamp	Status
3	ABCDE	Hans Meier	11.01.19	900
2	ABCDE	Hans Mayer	10.01.19	900
1	ABCDE	Hans Maier	08.01.19	900

[rogerpegler · Accepted solution]

Assuming Timestamp is a date field and not just text, then make Name a measure with an expression something like:

maxstring({<Timestamp={$(=max(Timestamp))}>}Name)

[Shubham_Deshmukh · Accepted solution]

 Try this : 

=MaxString({<Timestamp={"=$(=max(Timestamp))"}>}Name)

[Shubham_Deshmukh]

Mark the solution as an answer if it solves your issue