topic Selecting One Field based on Selection of Another in QlikView

Selecting One Field based on Selection of Another

proctors — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to limit a productivity such that the logged in user can look at only their data.

We are able to load the user name using OSUSER(). The table loads all clinicians (Clinician Name) and their emails (Email). I created a variable to determine if the OSUSER is equal to the email (the email contains the username before the @ symbol). For example USUSER () = jackson and my email would be jackson@email.hospital.edu. I can do some trim to just compare.

Anyway, I want to use an OnLoad trigger to have the Clinician Name Field selection box = the current OSUSER(), which would be Michael Jackson. How can I get the OnLoad trigger to select the full Clinician Name?

Thanks in advance

Re: Selecting One Field based on Selection of Another

Anil_Babu_Samineni — Tue, 14 Nov 2017 01:44:35 GMT

Perhaps you could try

SubFiled(email, '1', '@') as email_uname

And then,

If(OSUSER() = email_uname, 1, 0)

If(OSUSER() = email_uname, [clinical name])

Re: Selecting One Field based on Selection of Another

marcus_sommer — Tue, 14 Nov 2017 13:31:48 GMT

To control the data-access within an application there is a feature called Section Access.

- Marcus