Section access :Access Denied

[shwetagupta]

Hi All,

I am working on Section Access in Qlik Sense for the first time but everytime I am getting Access is denied.

-Even admin is getting the same.

-App is published in Everyone stream.

I have uploaded excel sheets for both Section Access and Section Application , following is the code for the same.

SECTION ACCESS;

LOAD

    Upper([ACCESS]) as ACCESS, // Took

    Upper([USERID])as USERID,

    Upper ([PASSWORD])as PASSWORD,

    UPPER([CATEGORY]) as Sales.Category;

LOAD

    [ACCESS],

    "USERID",

    "PASSWORD",

    CATEGORY

FROM [lib://Folder/Section Access.xlsx]

(ooxml, embedded labels, table is Section_Access);

Section Application;

LOAD

    Upper(Category) as Sales.Category,

    Product

FROM [lib://Folder/File.xlsx]

(ooxml, embedded labels, table is Purchase);

Please suggest where I am making mistake.

Any Help will be appreciated

[shwetagupta]

Its not working. If I am putting space, it is giving me all the category corresponding to all the user.

Problems for me are :

1. Administrator and all users can also see only those three category which are used for section access.

2. User which are allocated to particular Category can also see all the three category instead of their allocated Category corresponding to Section Access.

Thanks!!

[sujith1011]

Shweta,

Please provide some sample data from both , section_access spreadsheet as well as the data used for section_application

thanks!!

[shwetagupta]

hi,

Please confirm one thing, If I ll name the user with domain then do I need to link it with My Active directory or will it read/recognize user through domain.

When I was exploring what mistake I am making while working then I got to know my username are not working well though reduction field is working fine on  data.

What I am unable to do is to restrict the user.

Thanks in Advance

[sujith1011]

     r

I have placed sample screenshot of users, so data in spreadsheet should be like below

ACCESS, USERID, CATEGORY

USER, MASTER\PERFORMANCE4 ,CATEGORY1

USER, MASTER\PERFORMANCE43, CATEGORY2

ADMIN, MASTER\ADMINUSER1, *

ADMIN, MASTER\ADMINUSER2\          

Admin user "ADMINUSER1" will only be able to see CATEGORY1 or CATEGORY2

whereas "ADMINUSER2" should be able to see all DATA