Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Section access problem

Hi All,

I'm trying to implement section access for the first time. Please help.

I have tables with below structure

ACCESS USERID

ADMIN    A

USER     B

USER    C

USER   D

Column1 Column2

Value1     Value1

Value2    Value2

USERID ATTRIBUTE ATTRIBUTEVALUE

A               Column1    Value1

B              <nulll>         <null>

C              Column2     Value1

D              Column1     Value2

I'm trying to reduce data based on attributevalue.

1. Reduce different  columns for different users.

2. User with attribute data  as null should see everything.

Please help.

Regards,

Sravanthi

Tags (1)
2 Replies
ift_isabelle
Not applicable

Re: Section access problem

I think that the reduction is missing. Your script doesn't say what a specific user can't see.

We use Section Acces on de customerID. So we put CustumorID in the reduction.

section access;

LOAD * inline [

ACCESS, USERID, REDUCTION

ADMIN, <Servername>\ADMIN,*

USER, <Servername>\Cust1,123456

ADMIN, INTERNAL\SA_SCHEDULER,*

];

section application;

Servername as in the adress where you open the hub/qmc.

This code is in the first section after the parameters. After this my application load start.

* means see everything.

In your case you can put the UserID in Reduction.

Khan_Mohammed
Not applicable

Re: Section access problem

The ADMIN will see all data and user will see only USER data.

I don't understand why you using 2 different XL files?

I Used Sheet 2 in XL file, I edited it.

Usually the SA script should be

STAR is *;
SECTION Access;

USER:

.................


where 1=1;
LOAD * INLINE [
.......................
]
;
 
SECTION Application;

And this will work if we want to reduce it by a field but in your case your data doesn't seem right.