topic Re: Check if a value exists in a column in QlikView

Check if a value exists in a column

Wed, 08 Jun 2016 21:19:24 GMT

Hello,

I am using the OSUser() function to determine whether a user can see specific objects in my QV app. I have an inline script loading a field called SupervisorNTName which contains the AD account names for Supervisors that I want to be able to see specific objects, whereas others cannot.

How can I write a conditional statement that checks whether the current OSUser() value exists within the SupervisorNTName column?

Thanks,

Sal

Re: Check if a value exists in a column

Nicole-Smith — Wed, 08 Jun 2016 21:29:30 GMT

Something like the following should work:

if(match(OSUser(), $(=concat(distinct chr(39) & SupervisorNTName & chr(39),','))), 1, 0)

Explanation: match() checks if OSUser() is in any of the values returned by the concat() function.

Re: Check if a value exists in a column

Wed, 08 Jun 2016 21:40:47 GMT

Hi Nicole,

How can I modify that expression to work regardless of what values are selected for SupervisorNTName?

Re: Check if a value exists in a column

Nicole-Smith — Thu, 09 Jun 2016 14:11:06 GMT

You can add a 1 to the set analysis to tell it to ignore all selections:

if(match(OSUser(), $(=concat({1}distinct chr(39) & SupervisorNTName & chr(39),','))), 1, 0)

Re: Check if a value exists in a column

hytown2000 — Fri, 28 Apr 2017 18:20:10 GMT

I just did something very similar, there is a simple way to check if value exists in a field or not, FieldIndex(OSUser, SupervisorNTName), if exists, it returns the load order, else returns 0. You may need to remove the domain from OSUser().