Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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