Section Access sheet hide/show

[vikasgupta]

Hi Everyone

I am using following section access script :-

---------------------------------------------------------------

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,QV_ACCESS_LEVEL

ADMIN, ADMIN, ADMIN,1

USER,USER1,U2,2

USER,USER2,U2,3

];

Section Application;

------------------------------------------------------------------

QV_ACCESS_LEVEL is user group now i wants to hide and show sheet using following condition expression in sheet properties:

=min({1} TOTAL QV_ACCESS_LEVEL)> 3

or

=min({1} TOTAL QV_ACCESS_LEVEL)= 1

But its not working can anyone guide me what is going wrong in this expression ?

Thanks

Vikas Gupta

[#2]

Hi

You should only have one value of QV_ACCESS_LEVEL when you login, because the login will reduce that to only the value for your own user name, so your expression should simply be:

Only(QV_ACCESS_LEVEL) > 3

or

Only(QV_ACCESS_LEVEL) = 1

or even

QV_ACCESS_LEVEL > 3