Hide OMITed fields

Wed, 11 Apr 2012 07:32:27 GMT

Hi, is there a way to hide fields that certain users are not allowed (OMIT in Section Access) to see?

As it is now I have:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, ADMIN, ADMIN,

USER, SCM, SCM, test

USER, PM1, PM1, test

];

Section Application;

where 'test' is the field I want to hide for users SCM and PM1.

Now the users can see the field which is (unavailable). Can I simply hide unavailable fields?

Any other tips & tricks regarding design of reports with limited access rights?

Thanks.

/Mikael

Hide OMITed fields

jvitantonio — Wed, 11 Apr 2012 08:02:08 GMT

Hi,

You can use the function QVUser() and then play with the conditional show. for instance, if the object you want to hide is a list box, go to the list box properties -->LAyout --> Show on Conditional and put:

=If(QVUser() = 'SCM' or QVUser() = 'PM1', 0,1)

I hope this helps.

topic Hide OMITed fields in QlikView

Hide OMITed fields

Hide OMITed fields