Row level security using Section Access in Qlik Sense

[#1]

Hello all,

I am trying to implement row level security in Qlik sense.

Currently I have financial data which is going to open for all partners. However the requirement is that the specific partner should only see their specific financials. I believe the way to achieve it is using section access.

I have attached the excel file which I created for helping me achieve this and below is the code I am using.

Partner is a field (dimension) in my data source and "Siddharth Sheshadri" are the string entries in the dimension "Partner".

Now, what I am trying to achieve is when Siddharth Sheshadri logs in with his userID SheshadriS, he should only see his particular data. The rows have to restrict Siddharth Sheshadri from seeing other's financials.

Below is the code I wrote but does not work. It has some times even restricted me saying access denied.

Section Access; 

LOAD

    "PARTNER",

    "USERID"

FROM [lib://QVD_Finance/Access Level.xlsx]

(ooxml, embedded labels, table is Sheet1);

   Section Application; 

Can someone help me with this please.

[Anonymous · Accepted solution]

Hi,

Before section access logic screen shot below:

after section access logic:

Logic below:

section access;
LOAD * inline [
ACCESS, USERID,REDUCTION
USER, OPD\F29121,100
];

section application;
T1:
LOAD
    Key,
    Customer AS REDUCTION  
FROM [lib://Temp (opd_f29121)/Calculated_value.xlsx]
(ooxml, embedded labels, table is Sheet2);

Data:

LOAD
    Key,
    Customer,
    Society,
    "Date 1",
    "Date 2",
    Value
FROM [lib://Temp (opd_f29121)/Calculated_value.xlsx]
(ooxml, embedded labels, table is Sheet2);

Thanks

[Anonymous]

Please let me know if you need sample qvf for this and please mark the answer as helpful or correct so that other members of the community will understand that the question has been answered...

Thanks

[#4]

Hi Chandra,

Thanks for your help. I have tried to implement it today morning however was locked out of my own app while attempting to do so.

How can I achieve this while uploading an excel file?

And yes, a sample QVF will also be nice.

[Anonymous]

Hi Siddharth,

Please find the sample excel file I have used and the qvf for the section access .. if you are giving * for data reduction it is locking out .. it did to me also once

Thanks

[#6]

Thanks, sorry for the late reply.