Hello, I have a UX view that displays clocked...

(Joe Seiler) #1

Hello, I have a UX view that displays clocked-in entries from a slice.

I want to show the view only when I have a clock in time, but am awaiting a clock out time.

I tried using this in the UX’s Show_If constraint, and although it is recognized as valid, it doesn’t seem to work.

Any suggestions?

UX Show_IF= AND(ISNOTBLANK(Time Entries[Clock In Date/Time]), ISBLANK(Time Entries[Clock Out Date/Time]))

The idea is to show the view only when a have a row that is not blank from the [Clock In Date/Time] column, whilst also having the column [Clock Out Date/Time] from the same row blank.

Thanks in advance,

(Bellave Jayaram) #2

+Josiah Seiler,

Try this:

ISNOTBLANK(ANY(SELECT(Time Entries[Keycolumn], AND(ISNOTBLANK([Clock In Date/Time]), ISBLANK([Clock Out Date/Time])))))

(Joe Seiler) #3

Worked perfectly, thanks a ton!

(Bellave Jayaram) #4

You are welcome.