Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to perform section access in Qlik Sense using below code, but unable to do so....can anyone pls help me here
Sales_Master:
Load * Inline [
Product ID, Country, Geography
P101, India, APAC
P102, Japan, APAC
P103, UK, EMEA
P104, Austria, EMEA
P105, USA, AMER
P106, CANADA, AMER
];
EMP:
Load * Inline [
EMP ID, Product ID
E120, P101
E130, P101
E140, P102
E150, P103
E160, P105
];
SECTION ACCESS;
Laod * Inline [
ACCESS, USERID, PRODUCT ID
USER, E120, P101
USER, E130, P101
USER, E140, P102
USER, E160, *
];
SECTION APPLICATION;
Hi Digvijay,
I tried the same thing you mentioned here, but i am getting the below error:
You can now test our new Product SAM that will fully automate Section Access Generation product.
It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.
A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .
Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, and Reverse Engineer existing section Access a time saving for simple cases.
More details on our website or contact me at jp.golay@ebiexperts.com