Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

How do I do...

...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?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

try like:

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

View solution in original post

5 Replies
tresesco
MVP
MVP

try like:

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable

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'  

Not applicable

Hi,

Try somthing like this

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

where list is user_list....

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein