Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Prabhu1204
Creator
Creator

Section Access in Cloud version

Hello,

I have installed Qlik sense cloud trail from Qlik community. I gave implemented the simple section access script,

But i am getting the below error.

 

Prabhu1204_0-1597299738473.png

Below is my script;

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN

USER, USER1, U1, AFRICA,

USER, USER2, U2, ASIA,

USER, USER3, U3, EUROPE,

USER, USER3, U3, AMERICA

];

Section Application;


Data:

LOAD
TransactionID,
Upper(Region)as REGION,
CustomerNumber,
SaleValue,
"Items ordered"
FROM [lib://DataFiles/SectionAccessExampleData (1).xlsx]
(ooxml, embedded labels, table is Sheet1);

 

 

Could you please help me on this.

 

-Prabhu
2 Replies
johngouws
Partner - Specialist
Partner - Specialist

Hi: 

I am using this in section access: 

For the USERID you need to get the user's autho code and in my case _SP is the Sales person who has access. 

I hope this helps. 

Star is *;
Section access;

LOAD * inline [
ACCESS, USERID, _SP
ADMIN, auth0|a08XXXXXXXX,
USER, auth0|cf68e1c13d8XXXXXXXXXX, 22
USER, auth0|cfXXXXXXXX, 23
 ];
Section Application;

Prabhu1204
Creator
Creator
Author

Thanks, Hoe to get the auth code

-Prabhu