Discussion Board for collaboration on QlikView Scripting.
I am successfully protecting a particular data field (PROTECTEDFIELD1) from unauthorised access by certain users, by using section access in my script:
[My security spreadsheet.xlsx]
(ooxml, embedded labels, table is Sheet1);
In my spreadsheet I have the following table:
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:
Just duplicate the line with stating the other field value(s):
View solution in original post
You can also link to a second table so your user table can be 1:Many without duplication.
Table with just the OMIT fields...
See an example here...