Section Access

[noman212]

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.

[ashfaq_haseeb]

Hi,

Go through this sample.

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

Regards

ASHFAQ

[jagan · Accepted solution]

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.

[SunilChauhan]

see the attched file

User Id USERA-Aug

USERB -Sep

USERC-Oct

UserD-all data

hope this helps

[#5]

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.

[noman212]

Thanks jagan mohan for your reply