How to implement Section Access in Qlik Sense..

[Anonymous]

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;

[Cranjana91]

Hi Digvijay,

I tried the same thing you mentioned here, but i am getting the below error: 

Started loading data

Sales_Master << 9dc45377-4593-431d-837e-a8ae8a0386ab Lines fetched: 6 EMP << def2e44b-596e-47ef-9673-b3f8fe5780e8 Lines fetched: 5 INLFED << a488eddb-e9be-413d-af67-242e4346d62c Lines fetched: 4

Access was denied after reload.

Check that the user that reloads the script is included in the section access part of the script.

Data has not been loaded. Please correct the error and try loading again.

could you please assist.

Thank You.

Regards,

Ranjana

[jp_golay]

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