Section Access sheet hide/show

vikasgupta — Tue, 25 Jun 2013 09:44:45 GMT

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

=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

Re: Section Access sheet hide/show

Tue, 25 Jun 2013 09:48:07 GMT

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

Only(QV_ACCESS_LEVEL) = 1

or even

QV_ACCESS_LEVEL > 3

topic Section Access sheet hide/show in QlikView

Section Access sheet hide/show

Re: Section Access sheet hide/show