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

OMIT multiple fields

Hi,

I am successfully protecting a particular data field (PROTECTEDFIELD1) from unauthorised access by certain users, by using section access in my script:

SECTION Access;

LOAD ACCESS,

     NTNAME,

     OMIT

FROM

[My security spreadsheet.xlsx]

(ooxml, embedded labels, table is Sheet1);

In my spreadsheet I have the following table:

ACCESSNTNAMEOMIT
ADMINMYDOMAIN\GOD_USER
USERMYDOMAIN\LOWLY_EMPLOYEEPROTECTEDFIELD1


This works fine. When logged in as LOWLY_EMPLOYEE, I can't see PROTECTEDFIELD1.

My problem is: I can't figure out how to restrict access to more than one field. Is there a particular syntax? I have tried:

  • PROTECTEDFIELD1 PROTECTEDFIELD2
  • PROTECTEDFIELD1, PROTECTEDFIELD2
  • PROTECTEDFIELD1; PROTECTEDFIELD2

Any ideas?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: OMIT multiple fields

Just duplicate the line with stating the other field value(s):

ACCESSNTNAMEOMIT
ADMINMYDOMAIN\GOD_USER
USERMYDOMAIN\LOWLY_EMPLOYEE

PROTECTEDFIELD1

USER

MYDOMAIN\LOWLY_EMPLOYEEPROTECTEDFIELD2
1 Reply
MVP
MVP

Re: OMIT multiple fields

Just duplicate the line with stating the other field value(s):

ACCESSNTNAMEOMIT
ADMINMYDOMAIN\GOD_USER
USERMYDOMAIN\LOWLY_EMPLOYEE

PROTECTEDFIELD1

USER

MYDOMAIN\LOWLY_EMPLOYEEPROTECTEDFIELD2
Community Browser