topic Using Section Access in Qlik Cloud in App Development

Using Section Access in Qlik Cloud

tmumaw — Mon, 20 Dec 2021 21:08:46 GMT

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

Re: Using Section Access in Qlik Cloud

PriyankaShivhare — Wed, 21 Oct 2020 09:25:17 GMT

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];

Re: Using Section Access in Qlik Cloud

tmumaw — Thu, 22 Oct 2020 13:29:23 GMT

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