Discussion board where members can get started with Qlik Sense.
I'm trying to implement section access for the first time. Please help.
I have tables with below structure
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.
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.
LOAD * inline [
ACCESS, USERID, REDUCTION
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.
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.