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: 
tigerfan81
Contributor
Contributor

QVUser()

I have 4 seperate users that need access to certain sheets. I am currently utilized the sheet conditional statement  =qvuser()='user1'.

How would you include user2 into the formula to allow user1 and user2 to have access to the sheet?

Thanks in advance for your help....

1 Solution

Accepted Solutions
Not applicable

use match:

=Match(qvuser(),'user1','user2')

View solution in original post

6 Replies
Not applicable

use match:

=Match(qvuser(),'user1','user2')

tigerfan81
Contributor
Contributor
Author

Thanks, works great......

Not applicable

I tried this and so far it hasn't worked.  I made a varable too with =qvuser() as the code and it doesn't give a user.  I've tested on the server with IE and Ajax browsers.  Any ideas?

Not applicable

And how would you go about excluding users? I have a text object that needs to be seen by all users except some. What would be the synthax for this?

Thanks,

T

prieper
Master II
Master II

NOT MATCH(....)

HTH Peter

Not applicable

Thanks Peter, it works!