Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmxmikey
Creator
Creator

Security on Document

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

6 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
dmxmikey
Creator
Creator
Author

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...

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this a working example.

Authentication and Authorization in Qlikview

Regards

ASHFAQ

dmxmikey
Creator
Creator
Author

Unfortunately cannot access that

Thanks

Delivering the best in Foodservice...

ashfaq_haseeb
Champion III
Champion III

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