topic Re: Sheet Visible is Acess = Admin in QlikView

Sheet Visible is Acess = Admin

Thu, 20 Oct 2011 08:40:16 GMT

Hi All,

What must my conditional expression be if Ionly want a sheet visible if the user access level is ADMIN.

I have tried if(ACCESS = "ADMIN") but that does not work.

Regards

Jimmy

Sheet Visible is Acess = Admin

richard_chilvers — Thu, 20 Oct 2011 08:47:10 GMT

Hi Jimmy

I have never used the ACCESS field. But as a general rule within your Calculation Condition, I don't think you need the IF statement. Simply an expression which returns either 'true' or 'false'.

So in your case, ACCESS = "ADMIN" should be all you need.

Hope it works !

Richard

Re: Sheet Visible is Acess = Admin

Miguel_Angel_Baeyens — Thu, 20 Oct 2011 08:56:09 GMT

Hi there,

The Access field shouldn't work, but you have a function QVUser() that returns the user logged into the file. Assuming the following section access:

SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID
ADMIN, A1
USER, U1
];
SECTION APPLICATION;
// Your script here

You can create a condition to show only when the user A1 (admin) has logged in

QVUser() = 'A1'

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Sheet Visible is Acess = Admin

Thu, 20 Oct 2011 08:59:26 GMT

Hi Richard,

Thanks for the answer but no, it did not work.

Regards

Jimmy

Re: Sheet Visible is Acess = Admin

richard_chilvers — Thu, 20 Oct 2011 09:13:26 GMT

Hi Jimmy

As I mentioned, I did not understand the use of the ACCESS field, but good to see you now have a correct answer!

Regards