Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
dmxmikey
Contributor

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

Tags (2)
6 Replies
MVP & Luminary
MVP & Luminary

Re: Security on Document

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
Contributor

Re: Security on Document

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

Re: Security on Document

Hi,

Check this a working example.

Authentication and Authorization in Qlikview

Regards

ASHFAQ

dmxmikey
Contributor

Re: Security on Document

Unfortunately cannot access that

Thanks

Delivering the best in Foodservice...

Re: Re: Security on Document

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


Re: Re: Security on Document