topic Re: Check a list for a specific value in QlikView

Check a list for a specific value

Anonymous — Mon, 13 Apr 2015 16:11:28 GMT

Hi all. A simple question I think...

I need to be able to check a field to see if any of the values match the user.

EG if OSuser() is in field [Priority A users], yes, no.

It sounds simple to check a list for a value but I can't do it.

Any ideas.

Many thanks

David

Re: Check a list for a specific value

SunilChauhan — Mon, 13 Apr 2015 16:17:34 GMT

if(exists( [Priority A users],Osuser()),'Yes','No')

fro example

if(exists( [Priority A users],domein\username,'Yes','No')

hope this helps

Re: Check a list for a specific value

Anonymous — Tue, 14 Apr 2015 09:14:43 GMT

Hi, thanks for that but it doesn't seem to work. I need to be able to use this logic in the "front end" and not in the script. The function "exists" is not something I have available to use in say a text box.

Any ideas for how to achieve this in a text box? Each user who looks at the system needs to be verified (I'm try to keep away from section access if I can).

Thanks

Re: Check a list for a specific value

Anonymous — Tue, 14 Apr 2015 09:24:08 GMT

Hi David,

Its better to create a variable which has the value of current user logged in.

For example vuser=OSuser()

And you can use this variable anywhere in your report.

Thanks and Regards,
Laxmi

Re: Check a list for a specific value

Anonymous — Tue, 14 Apr 2015 09:46:15 GMT

Many thanks, yes that does the trick.

Re: Check a list for a specific value

jagan — Tue, 14 Apr 2015 09:47:33 GMT

Hi,

Try like this

If(Count({1<[Priority A users] ={'$(=OSUSER())'}>} [Priority A users]) > 0, 'Yes', 'No')

Hope this helps you.

Regards,

Jagan.