Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
Load * INline [
access, userid, password, companyid
user, a, a, 1
user, b, b, 2
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
Here you will find many informations and examples about Section Access.