Using Section Access in Qlik Cloud

[tmumaw]

Good morning everyone,

I'm having an issue trying to get section access to work in Qlik Cloud.  It's ignoring it all together.  It does work on prem though.  Has anyone got this to work and would like to share some tips and tricks?

Here's my script:

Section Access;
LOAD
"ACCESS",
"USERID",
"PROFIT CENTER"
FROM [lib://QVD/Section Access/QSAccessTest.xlsx]
(ooxml, embedded labels, table is Document_TB03);

Section Application;

xlsx looks like this:

USER   DAVEY\MUMAWT   

USER   DAVEY\BOOTHC         130431

MUMAWT should see everything and BOOTHC should only see profit center 130431

[PriyankaShivhare]

May be try this

Section Access;
LOAD * inline [
ACCESS,USERID,KEY
USER,DAVEY\MUMAWT,
USER,DAVEY\BOOTHC ,1
];

Section Application;

Data_Reduction:
LOAD * inline [
PROFIT CENTER,KEY
130431,1];

[tmumaw · Accepted solution]

Thanks for the response.  I'm new to section access and I found my issue.  PROFIT CENTER should have been Profit Center (Mixed Case).  Thanks