topic Re: Section access and exclude fields. in QlikView

Section access and exclude fields.

joris_lansdaal — Sat, 13 Aug 2016 13:39:09 GMT

‌Hi all,

i've used section access to grant or exclude users access to sheets. Now I'm asked to exclude whole fields. Let's assume I have only two fact fields named volume and profit. what's the best way to exclude users from the field profit?

i've read a lot about section access but could'nt find the answer.

thanks

Re: Section access and exclude fields.

trdandamudi — Sat, 13 Aug 2016 14:02:45 GMT

You can use the Omit field. In the below script when user DAVID logs in, he will not see the filed "SALES". Hope this helps...

LOAD * Inline [

ACCESS,USERID,OMIT,AUTHID,DISPLAY_SHEET1

ADMIN,ADMIN,,*|*|*,1

USER,JOHN,,JOHN|EMEA|A,1

USER,JOHN,,JOHN|NAM|A,1

USER,JOHN,,JOHN|NAM|B,1

USER,JOHN,,JOHN|NAM|C,1

USER,DAVID,SALES,DAVID|*|*,0

];

Re: Section access and exclude fields.

trdandamudi — Sat, 13 Aug 2016 14:05:31 GMT

Also please go thru the attached file which has examples also:

Re: Section access and exclude fields.

joris_lansdaal — Sat, 13 Aug 2016 16:11:29 GMT

‌thanks! it does ring a Bell. I already have this document printed and in front of me.... I just looked past it I guess.

anyway, again thanks.

Joris.

Re: Section access and exclude fields.

trdandamudi — Sat, 13 Aug 2016 17:34:08 GMT

You are welcome... and yes sometimes we spend lot of time for simple things even though it is in front of us.....Enjoy your day...