Dynamic Selection In Qlikview

[#1]

I have a requirement where i am showing multiple values in a sheet.

For example i have table 1, table 2, table 3, table 4

Now table 1 has a max date of 29th jun

Table2 has a max date of 28th june

Similarly table 3 has 29th June

Table 4 --> 28th June

So the sheet should display the variable that max from each table. But i am not able to do the same as its showing only 29th Jun data and leaving out 28th.

Presently:

Want it to be as :

Any ideas. The list box is selected from common columns across while the individua date times are unique columns across.