Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harson
Contributor III
Contributor III

Data not display on the table until selection made

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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

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

...

Capture.JPG

View solution in original post

2 Replies
tresesco
MVP
MVP

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

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

...

Capture.JPG

harson
Contributor III
Contributor III
Author

Thanks