Data not display on the table until selection made

[harson]

Hello community,

I have a hang on QlikView.

To determine the hours of entry for employees after lunch break, I need to find the value of Login closest to the scheduled time (each employee has their own schedule)

I found the good value, but it’s not display on the table until selection made on the ID (employee)

Any ideas? (attached an example)

Thanks in advance.

Sorry for my English, I don’t speak English very well.

[tresesco · Accepted solution]

Replace your set analysis expressions with if-expression, like in attached.

Left Max Value = Max(if(Login<=LoginPlanning,Login))

...

[harson]

Thanks tresesco  

You are the best,