topic Re: Sheet property access using sheet properties condition in App Development

Sheet property access using sheet properties condition

random_user_3869 — Fri, 21 Jan 2022 17:15:11 GMT

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

Re: Sheet property access using sheet properties condition

rubenmarin — Sat, 22 Jan 2022 08:18:04 GMT

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 ];

Re: Sheet property access using sheet properties condition

random_user_3869 — Mon, 24 Jan 2022 08:48:18 GMT

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

Re: Sheet property access using sheet properties condition

rubenmarin — Mon, 24 Jan 2022 09:03:37 GMT

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.