Row level security using Section Access in Qlik Sense
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.