Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone
how to implement row level and column level Security in qlikview with example?
Thank You
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):
You have also tons of documents in the community:
This one a few simple example about row security:
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!!
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);
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);
STILL I GET AN ERROR...
"file not found"
What error message are you getting? Can you post sample image
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.
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
Check your Excel data source "Data.xlsx". Is there a column present with the name ACCESS in all capitals on worksheet tbl_cust?