Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
i work for a company that use section access in qlik cloud to manage access to the business users.
Although section access is effective, i would like to improve it by limiting access to some **bleep**s regarding some business users
in qlik cloud/qlik sense (i'm using qlik cloud saas) when i go to a sheet i get to the property sheet
Then i try to use the id regarding the section access to limit the access to one or more user. so my syntax is the following
i consider myself as '_user_1' and i have full access to qlik cloud
=If(wildmatch([USER.EMAIL],'*user_1*','*user_2*'),1,0) in the display window (in the picture it is in "condition d'affichage" box.
I faced some issue with that because the sheet on one hand disapear and on one hand appear again so it might not be the right approach.
Do you thing my expression could be improved somewhat ?
Thank you
Hi, I would prefer to have 1 or 0 loaded in section access:
Load * INLINE [
ACCESS, USER.EMAIL, SALES, MARGIN
USER, USER1@example.com, 0, 0
USER, USER2@example.com, 1, 0
ADMIN, USER3@example.com, 1, 1
];
So the condition to show the sheet could be only "=SALES" or "=MARGIN" meaning the USER1 doesnt' sees sales or margin related sheets, USER2 sees sales related but not margin sheets and USER3 sees all.
you can also create calcualted fields:
LOAD
*,
If(wildmatch([USER.EMAIL],'*USER1*','*USER2*'),1,0) as SALES
INLINE [
ACCESS, USER.EMAIL
USER, USER1@example.com
USER, USER2@example.com
ADMIN, USER3@example.com
];
so if i understant clearly,
the following statement
Load * INLINE [
ACCESS, USER.EMAIL, SALES, MARGIN
USER, USER1@example.com, 0, 0
USER, USER2@example.com, 1, 0
ADMIN, USER3@example.com, 1, 1
];
So basically the field SALES and MARGIN are field that will link to the sheet named 'SALES" and 'MARGIN' in my application. Is that right ?
Thank you
Hi, yes, when each user opens the app will have 1 or 0 in each field.
I forgot: you also need a table outside section access (in section application) with both values for each field:
SALES:
LOAD * Inline [
SALES
0
1
];
So when a user opens the app, the section access applies reduction and only one value for each field is avalable, and there is no option to access the othe value.