topic Re: How do I do... in QlikView

How do I do...

samvile18 — Fri, 31 Jan 2014 09:17:58 GMT

...the following:

I want to only show a sheet where the OSUser is in a list of 5 people, I know I need to add some syntax to the conditional show of the sheet....I just can't figure out what that syntax should be.

I'm thinking that maybe a match could work, I just can't get it to!

Can anyone help please?

Re: How do I do...

tresB — Fri, 31 Jan 2014 09:19:54 GMT

try like:

=Match(OsUser(), 'User1', 'User2', 'User3')

Re: How do I do...

Gysbert_Wassenaar — Fri, 31 Jan 2014 09:20:29 GMT

if(Match( OSUser() , 'DomainNameHere\UserNameHere1', 'DomainNameHere\UserNameHere2' , ... etc ) , 1 , 0)

Re: How do I do...

Fri, 31 Jan 2014 09:21:39 GMT

Insert in Sheet Properties Show Conditional expression this:

i.e.

OsUser()='Domani\Name1' or osuser()='Domani\Name2' or osuser()='Domani\Name3' or osuser()='Domani\Name4' or osuser()='Domani\Name5'

Re: How do I do...

Fri, 31 Jan 2014 09:26:08 GMT

Hi,

Try somthing like this

=if(wildmatch(Concat(list,'@'),'*'&osuser()&'*'),1,0)

where list is user_list....

Re: How do I do...

jonathandienst — Fri, 31 Jan 2014 09:26:55 GMT

Adduming you have the user list in a variable:

Let vUserList = 'intranet\fredb,intranet\joes,intranet\maryp';

Then you could conditionally show the tab using:

=WildMatch('$(vUserList)', '*' & OSUser() & '*') > 0

HTH

Jonathan