Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amirmohamed
New Contributor III

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
Valued Contributor II

Re: Qliksense section access does not reduce data

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

];

6 Replies
agigliotti
Honored Contributor II

Re: Qliksense section access does not reduce data

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
New Contributor III

Re: Qliksense section access does not reduce data

Hi Andrea,

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

eduardo_dimperi
Valued Contributor II

Re: Qliksense section access does not reduce data

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
Valued Contributor II

Re: Qliksense section access does not reduce data

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
New Contributor III

Re: Qliksense section access does not reduce data

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
New Contributor III

Re: Qliksense section access does not reduce data

Thank you both Andrea and Mohammed,

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