Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Security

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.

1 Solution

Accepted Solutions
Employee
Employee

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.

View solution in original post

5 Replies
Partner
Partner

Hi soha1902,

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

HTH - Andy

Creator II
Creator II

Refer the below link,it may helps you.

QlikView Section Access Examples

Not applicable

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,  USER2USER2,  AUS

USER,  USER3USER3,  NZ

USER,  USER4USER4,  IND


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


Thanks

Avinash

Not applicable

Employee
Employee

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.

View solution in original post