topic Re: Data not display on the table until selection made in QlikView

Data not display on the table until selection made

harson — Fri, 09 Feb 2018 05:01:28 GMT

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.

Re: Data not display on the table until selection made

tresB — Fri, 09 Feb 2018 05:15:46 GMT

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

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

...

Re: Data not display on the table until selection made

harson — Fri, 09 Feb 2018 05:21:10 GMT

Thanks tresesco

You are the best,