Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Row level security using Section Access in Qlik Sense

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.

1 Solution

Accepted Solutions
gompa786
Creator III
Creator III

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

View solution in original post

5 Replies
gompa786
Creator III
Creator III

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

gompa786
Creator III
Creator III

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

Not applicable
Author

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.

gompa786
Creator III
Creator III

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

Not applicable
Author

Thanks, sorry for the late reply.