Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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?
Delivering the best in Foodservice...
Check this a working example.
Authentication and Authorization in Qlikview
Unfortunately cannot access that
Check below script for implementing Authentication and Authorization in Qlikview.
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REDUCTION
ADMIN, Admin, password, *
USER, Sales, password1, 1
USER, Market, password1, 2
star is *;
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
Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option
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