topic Section Access and a variable in QlikView

Section Access and a variable

Mon, 29 Jun 2009 22:50:53 GMT

In am using section access for user logins. I want to put into a variable the "userid" of the person who logged in. I can't seem to get it to work. How can I do this?

Thanks,

Stephen

Section Access and a variable

Anonymous — Mon, 29 Jun 2009 23:53:44 GMT

It's a function:
=QVUser()

Section Access and a variable

Tue, 30 Jun 2009 00:09:50 GMT

Thanks. That did what I needed.

Section Access and a variable

Tue, 30 Jun 2009 03:00:10 GMT

Now I am having trouble changing the condition on a sheet. What I want to do is set the condition to 1=2 (hide) or 1=1(show) depending on who is login to the document. I have the user name OK but am having trouble setting the condition. Need help.

Thanks,

Stephen

Section Access and a variable

Anonymous — Tue, 30 Jun 2009 03:46:34 GMT

Stephen,
The condion could be:
QVUser() =STEPHEN
Or something like this.

Section Access and a variable

Tue, 30 Jun 2009 04:01:24 GMT

Sorry I should have given more detail. I have many users that log in and I have to run the user through a macro when the document is opened that will have an if or select case routine to determine whether or not to show the sheet to the user.

Section Access and a variable

Anonymous — Tue, 30 Jun 2009 06:55:12 GMT

Well, I'm pretty much sure you can do it without a macro. For example, use dynamic data reduction, if you're not using it already. Example:
Add a field, say "SHOW" in section access and in section application, probably as data island. Use the conditions in section access to assgn value 'YES' (or 1, if you prefer) for users who will have access to the restricted objects, and 'NO' ( or 0) for all other users. Now your show condition will be:
SHOW = 'YES' (if you use YES/NO)
or simply
only(SHOW) (if you use 1/0)
Note: there is no need for 1=2 and 1=1. Simply 0 in condition will hide an object, and 1 will show it.