5 Replies Latest reply: Jun 27, 2016 3:27 AM by Siddharth Sheshadri RSS

    Row level security using Section Access in Qlik Sense

    Siddharth Sheshadri

      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.