topic Re: QVUser() in QlikView

QVUser()

tigerfan81 — Mon, 27 Aug 2012 18:26:04 GMT

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

Re: QVUser()

Mon, 27 Aug 2012 18:30:03 GMT

use match:

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

Re: QVUser()

tigerfan81 — Mon, 27 Aug 2012 19:13:59 GMT

Thanks, works great......

Re: QVUser()

Tue, 02 Oct 2012 15:03:55 GMT

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?

Re: QVUser()

Mon, 01 Dec 2014 09:18:00 GMT

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,

Re: QVUser()

prieper — Mon, 01 Dec 2014 10:44:37 GMT

NOT MATCH(....)

HTH Peter

Re: QVUser()

Mon, 01 Dec 2014 10:53:30 GMT

Thanks Peter, it works!