Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
soha1902
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
Luis_Cortizo
Former Employee
Former 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
awhitfield
Partner - Champion
Partner - Champion

Hi soha1902,

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

HTH - Andy

d_koti24
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

Luis_Cortizo
Former Employee
Former 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.