topic Re: Security on Document in QlikView

Security on Document

dmxmikey — Wed, 12 Nov 2014 13:47:39 GMT

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

Re: Security on Document

Gysbert_Wassenaar — Wed, 12 Nov 2014 13:55:30 GMT

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

Re: Security on Document

dmxmikey — Wed, 12 Nov 2014 16:35:39 GMT

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

ashfaq_haseeb — Wed, 12 Nov 2014 16:38:04 GMT

Hi,

Check this a working example.

Authentication and Authorization in Qlikview

Regards

ASHFAQ

Re: Security on Document

dmxmikey — Wed, 12 Nov 2014 16:51:15 GMT

Unfortunately cannot access that

Thanks

Delivering the best in Foodservice...

Re: Re: Security on Document

ashfaq_haseeb — Wed, 12 Nov 2014 16:59:43 GMT

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

its_anandrjs — Wed, 12 Nov 2014 17:23:38 GMT

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