New to Qlik Sense

[amirmohamed]

     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

[agigliotti]

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]

Hi Andrea,

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

[eduardo_dimperio]

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 · Accepted solution]

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]

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]

Thank you both Andrea and Mohammed,

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