Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
joris_lansdaal
Contributor

Section access and exclude fields.

‌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

1 Solution

Accepted Solutions
trdandamudi
Honored Contributor

Re: Section access and exclude fields.

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

];

4 Replies
trdandamudi
Honored Contributor

Re: Section access and exclude fields.

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

];

trdandamudi
Honored Contributor

Re: Section access and exclude fields.

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

joris_lansdaal
Contributor

Re: Section access and exclude fields.

‌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.

trdandamudi
Honored Contributor

Re: Section access and exclude fields.

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...

Community Browser