topic Re: Security in QlikView

Security

soha1902 — Thu, 13 Aug 2015 08:26:55 GMT

Hi All,

In my dashboard, I am having data for four countries like US, AUS, NZ and IND.

Now I want to implement the security for 4 users user1, user2, user3 and user4.

user1 will be able to see only US related data, User2 only AUS data and remaining 2 users will able to see all the data.

how I'll implement this type of security in QlikView.

Please share the script as I am using personal edition.

Thanks in advance.

Re: Security

awhitfield — Thu, 13 Aug 2015 08:31:19 GMT

Hi soha1902,

you would do this by using SECTION ACCESS, please see the attached document that will get you started.

HTH - Andy

Re: Security

d_koti24 — Thu, 13 Aug 2015 08:31:26 GMT

Refer the below link,it may helps you.

QlikView Section Access Examples

Re: Security

Thu, 13 Aug 2015 08:33:49 GMT

Hi Soha,

You have to go for section access to implement restrictions for users to access dashboard

Access, UserID, Password, Dashboard

ADMIN, ADMIN, ADMIN, *

USER, USER1, USER1, US

USER, USER2, USER2, AUS

USER, USER3, USER3, NZ

USER, USER4, USER4, IND

The Above table should be written in caps only. '*' means admin has access to all dashboards

Thanks

Avinash

Re: Security

Thu, 13 Aug 2015 08:36:12 GMT

hI Soha,

Check for the below link

http://www.analyticsvidhya.com/blog/2014/12/qlikview-section-access-document-authorization/

Re: Security

Luis_Cortizo — Thu, 13 Aug 2015 08:41:14 GMT

Here's a sample script code that you will need to adapt to your requirements (probably changin USERID/PASSWORD for NTNAME and the name of the Countries field:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, COUNTRY

Admin, Admin, Password1

User, User1, PasswordUser1, US

User, User2, PasswordUser2, AUS

User, User3, PasswordUser3

User, User4, PasswordUser4

];

Section Application;

Section access statements can be as simple as that or really, really complex

I believe you'll find the following links very interesting:

https://www.youtube.com/watch?v=2rF9v_TdbVk

Section Access best practice - YouTube

A Primer on Section Access

Data Reduction – Yes, but How?

Basics for complex authorization

There are lots of information and examples on the Community, but this links are a good place to start

Hope it helps.

Best regards.