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

Help with Section Access

I have a field called CompanyID. The field contain numbers 1,2,3,4.

I want to create user and password for each CompanyID,

So the system will be filtered by user's CompanyID.

My model is only do one binary load from schema file.

Any suggestions for achieve that?

thanks and sorry for bad english

1 Solution

Accepted Solutions
Not applicable

Re: Help with Section Access

section access;

Load * INline [

access, userid, password, companyid

user, a, a, 1

user, b, b, 2

];

section application;

In the above script user with userid = a, password = a will see data related to companyid = 1

make sure to include strict exclusion in document properties and companyid should be in capitals in the actual DataModel

2 Replies
Not applicable

Re: Help with Section Access

section access;

Load * INline [

access, userid, password, companyid

user, a, a, 1

user, b, b, 2

];

section application;

In the above script user with userid = a, password = a will see data related to companyid = 1

make sure to include strict exclusion in document properties and companyid should be in capitals in the actual DataModel

Re: Help with Section Access

Here you will find many informations and examples about Section Access.

- Marcus

Community Browser