Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
amirmohamed
Creator
Creator

Qliksense section access does not reduce data

     Hi all,

I am using Qlik sense and created section access and section application exactly like Qlik view but in Qliksense it still shows me all data without reducing the data based on section access.

Would you please help me with this.

this is the section access script

Section Access;

LOAD

  *

INLINE

[

  ACCESS, USERID,     LINK

    ADMIN,  amir,     account1

    ADMIN,  omar,     account2

];

Section Application;

NoConcatenate

LOAD

  *

INLINE

[

  LINK,  cust_group_code

  account1,  'account1'

  account2, 'account2'

];

when I am using this same script in Qlikview and activate the initial reduction in Document-Opening it does what i want

1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Dear,

As Mentioned by agigliotti‌  in the Section Access all the field names and Field values should be in the upper case.

below script:

Section Access;

LOAD * INLINE

[

  ACCESS, USERID,     LINK

    ADMIN,  AMIR,*

    ADMIN, OMAR ACCOUNT2

    USER,ALI,ACCOUNT1

];

Section Application;

//  if your users are available in Active Directory then   USERID Data should be DOMAINNAME\AMIR etc.

// Section Access will not work in Qlik Sense Desktop.

NoConcatenate

LOAD * INLINE

[

  LINK,  cust_group_code

  ACCOUNT1,  account1

  ACCOUNT2, 'account2

];

View solution in original post

6 Replies
agigliotti
Partner - Champion
Partner - Champion

first of all make all section access content uppercase.

secondly create a new user with USER access in your section access table.

and thirdly verify data reduction for that user.

amirmohamed
Creator
Creator
Author

Hi Andrea,

I have done that but i get the same result Access is Denied.

eduardo_dimperio
Specialist II
Specialist II

Hi Amir,

I dont understant what you want to do. You want bring only results from Section Application; where your users are amir and omar?

mdmukramali
Specialist III
Specialist III

Dear,

As Mentioned by agigliotti‌  in the Section Access all the field names and Field values should be in the upper case.

below script:

Section Access;

LOAD * INLINE

[

  ACCESS, USERID,     LINK

    ADMIN,  AMIR,*

    ADMIN, OMAR ACCOUNT2

    USER,ALI,ACCOUNT1

];

Section Application;

//  if your users are available in Active Directory then   USERID Data should be DOMAINNAME\AMIR etc.

// Section Access will not work in Qlik Sense Desktop.

NoConcatenate

LOAD * INLINE

[

  LINK,  cust_group_code

  ACCOUNT1,  account1

  ACCOUNT2, 'account2

];

amirmohamed
Creator
Creator
Author

Hi Eduardo,

No I am not trying to only bring section access and application, i have a table underneath the section and application access.

amirmohamed
Creator
Creator
Author

Thank you both Andrea and Mohammed,

Now I am trying to show sheet based on user access using App object access (i guess)