Pass field name's value to expression/variable

[cfountain72]

Hello,

I am trying to create a turnaround time, where the user selects the Base Start Time from three one of the three possible fields: Arrival Time, Inpatient Admit Time, Outpatient Admit Time.

So if the user selected Arrival Time, the result would be Event Time -Arrival Time. I could use an If statement, but was wondering if there's a more efficient way to do this. I tried Event Time - Base Start Time, but that obviously doesn't work.

How do I get the actual time stamp inserted into the expression based on the user's field name selection?

Thanks,

Chris

[Or]

Event Time - $([Base Start Time]) should work, I believe. The magic of dollar-sign expansion! https://community.qlik.com/t5/Qlik-Design-Blog/The-Magic-of-Dollar-Expansions/ba-p/1471979

[cfountain72]

Hi Or,

Thanks for the suggestion, but that didn't quite work.

[Or]

Oops. The = at the start of the expansion escaped my message. I found it hiding behind another message.

Event Time - $(=[Base Start Time]) 

Sample: