topic Re: Section Access based on an internal QS table. in App Development

Section Access based on an internal QS table.

robin_heijt — Fri, 02 Apr 2021 07:45:42 GMT

Hi,

So I was wondering if it is somehow possible to base section access based upon an internal Qlik Sense Table?

If I would combine 3 tables through a join.

AD_GROUPS:

AD Group,

Unique ID

From: File1;

left join AD_GROUPS
POSITIONID:

Position ID,

Unique ID

From file 2;

Left Join AD_GROUPS

GLOBALID:

Unique ID,

Global ID

From File 3;





Load

Unique ID,

Global ID,

Position ID,

AD Group

From AD_GROUPS;

Can I now create a section access that will use the string of the AD Group field and give access to all associated lines in field Position ID?

Or does it have to be a pre-created table?

Thanks.

Re: Section Access based on an internal QS table.

Gysbert_Wassenaar — Wed, 23 Jan 2019 15:46:01 GMT

You can create a section access table from any source including tables you created earlier in the load script. What you can't do is create a section access table that tries to load data from a table that doesn't exist yet.

Re: Section Access based on an internal QS table.

robin_heijt — Wed, 23 Jan 2019 16:06:20 GMT

Hi Gysbert,

Thanks for your response.

Could you clarify for me how I would write this into the section access?
Would it be:?

Star is *;
Section Access;
Load * Inline [
ACCESS,	USERID,								RESTRICT	
ADMIN,	*****\*******,						           *			
USER, 	ADGROUP,							POSITIONID

Thanks for your input

Re: Section Access based on an internal QS table.

Gysbert_Wassenaar — Wed, 23 Jan 2019 16:30:51 GMT

SomeTable:
LOAD ...fields... FROM ...somewhere...;

Section Access;
LOAD ...stuff... RESIDENT SomeTable;