topic Re: Section Access in QlikView

Section Access

noman212 — Tue, 21 Oct 2014 05:45:37 GMT

Hi all,

I want to hide some data from different users for example if i have 3 months records(Aug, Sep, Oct) i want to show Aug's record to User A , Sept records to User B and Oct Records to user c. and admin have rights to visible all records aug,sep and oct.

Re: Section Access

ashfaq_haseeb — Tue, 21 Oct 2014 05:50:01 GMT

Hi,

Go through this sample.

http://community.qlik.com/docs/DOC-5973

Regards

ASHFAQ

Re: Section Access

jagan — Tue, 21 Oct 2014 05:58:16 GMT

Hi,

Check below script for implementing Authentication and Authorization in Qlikview.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, A, password1, Aug

USER, B, password1, Sep

USER, C, password1, Oct

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Month,

Aug, Aug

Sep, Sep

Oct, Oct];

Sales:

LOAD * INLINE [

Month, Sales

Aug, 100

Aug, 200

Aug, 4646

Sep, 755

Sep, 422

Sep, 42

Oct, 2

Oct, 453

Oct, 54

Oct, 45

];

When you login as Admin, you can see all data in the dashboard, when you login as A then you can see only Aug data and when you login as B you can see only Sep data and so on.

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option

Hope this helps you.

Regards,

Jagan.

Re: Section Access

SunilChauhan — Tue, 21 Oct 2014 06:01:53 GMT

see the attched file

User Id USERA-Aug

USERB -Sep

USERC-Oct

UserD-all data

hope this helps

Re: Section Access

Tue, 21 Oct 2014 06:20:59 GMT

Hi,

Check below script for implementing Authentication and Authorization in Qlikview.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, A, password1, Aug

USER, B, password1, Sep

USER, C, password1, Oct

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Month,

Aug, Aug

Sep, Sep

Oct, Oct];

Sales:

LOAD * INLINE [

Month, Sales

Aug, 100

Aug, 200

Aug, 4646

Sep, 755

Sep, 422

Sep, 42

Oct, 2

Oct, 453

Oct, 54

Oct, 45

];

When you login as Admin, you can see all data in the dashboard, when you login as A then you can see only Aug data and when you login as B you can see only Sep data and so on.

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option

here we have to use Field Level Security, in Document Properties we use OMIT Function.

Re: Section Access

noman212 — Tue, 21 Oct 2014 07:04:33 GMT

Thanks jagan mohan for your reply