Security

[soha1902]

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.

[awhitfield]

Hi soha1902,

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

HTH - Andy

[d_koti24]

Refer the below link,it may helps you.

QlikView Section Access Examples

[#4]

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

[#5]

hI Soha,

Check for the  below link

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

[Luis_Cortizo · Accepted solution]

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.