Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a qlikview document that I would like to restrict access of data depending on who the person is. Currently i copy the master file and filter it down using a field and locking it on the filter.
Attached is my qvw. As an example would like rep A to only see reports for his customers only.
So am struggling how to use section access for this.
Thanks
Sorry, but I'm not going to download, modify and upload a qvw document of that size. Read this document: Introduction to Section Access. If you've done that and you still have problems then describe what you've tried and what happened. And try creating a small example document. See this document for how to do that: Preparing examples for Upload - Reduction and Data Scrambling
Have read through the document is there an easier way of sending a smaller size qvw as am struggling creating the script?
Thanks
Delivering the best in Foodservice...
Unfortunately cannot access that
Thanks
Delivering the best in Foodservice...
Check this
Check below script for implementing Authentication and Authorization in Qlikview.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REDUCTION
ADMIN, Admin, password, *
USER, Sales, password1, 1
USER, Market, password1, 2
];
Section Application;
star is *;
Departments:
LOAD * INLINE [
REDUCTION, Dept,
1, Sales
2, Marketing];
Sales:
LOAD * INLINE [
Dept, Sales
Sales, 100
Sales, 200
Sales, 4646
Sales, 755
Sales, 422
Sales, 42
Marketing, 2
Marketing, 453
Marketing, 54
Marketing, 45
];
When you login as Admin, you can see all data in the dashboard, when you login as Sales then you can see only Sales data and when you login as Market you can see only Marketing data.
User and password details for this application is
User Name Password
Admin, password
Sales, password1
Market, password1
Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option
Hi,
Go through the attached document i thing this helps to implement the Section access security
Introduction to Section Access
Preparing examples for Upload - Reduction and Data Scrambling
Introduction to Section Access
http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access
Regards
Anand