Row Level Security in Qlikview

[Anonymous]

Hello everyone

how to implement row level and column level Security in qlikview with example?

Thank You

[rubenmarin]

Hi prachi, row and column security can be applied using section access, in qlik help there is an example using row level security (using the REDUCTION field) and column security (using OMIT):

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/Security/dynamic-data-...

You have also tons of documents in the community:

Section Access

This one a few simple example about row security:

QlikView Section Access Examples

[Anonymous]

Hi

This can be implement by using Section Access.

Row Level

Column Level

Chart Level

Document Level

Object Level

Have a look: Good Explanation with Example

Various levels of security implementation using Section Access

Hope it helps!!

[Anonymous]

i get an error while i am running below script  'FILE NOT FOUND <ACCESS>'

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    USER, PRACHI, 123

    ADMIN, BHAGWAT, 456

];

Section Application;

row_level:

LOAD ACCESS,

     CUST_ID,

     CUST_NAME,

     PROD_ID

FROM

[..\..\Qlikview\Source\Data.xlsx]

(ooxml, embedded labels, table is tbl_cust);

[rubenmarin]

Hi, those 3 fields are for document security only, if you want to add row level you need another field that does the reduction, ie:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, AREA

    USER1, PRACHI, 123, 1

    USER2, PRACHI2, 123, 2

    ADMIN, BHAGWAT, 456, *

];

Section Application;

row_level:

LOAD AREA, //This should be a real field with values related to users

     CUST_ID,

     CUST_NAME,

     PROD_ID

FROM

[..\..\Qlikview\Source\Data.xlsx]

(ooxml, embedded labels, table is tbl_cust);

[Anonymous]

STILL I GET AN ERROR...

"file not found"

[Anonymous]

What error message are you getting? Can you post sample image

[devarasu07]

Hi,

Here is simple analysis - row level security option through section access

1) keep below script into back end

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, AFRICA

USER, USER2, U2, AMERICA

USER, USER3, U3, ASIA

USER, USER4, U4, EUROPE

USER, USER5, U4, AMERICA

USER, USER5, U5, *

];

Section Application;

SALES:

LOAD * INLINE [

REGION, PROFIT

AFRICA, 1000

AMERICA, 2000

ASIA, 3000

EUROPE, 4000

OCEANIA, 5000

];

2) STEP2,

3) IF ANY ISSUE IN OUR Setup, by grading below order admin security will help to open doc.

[rubenmarin]

If it says "file not found" seems than the path to the xlsx is different:

[..\..\Qlikview\Source\Data.xlsx]

This one should point where your xlsx is

[Peter_Cammaert]

Check your Excel data source "Data.xlsx". Is there a column present with the name ACCESS in all capitals on worksheet tbl_cust?