Section Access based on an internal QS table.

[robin_heijt]

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.

[Gysbert_Wassenaar · Accepted solution]

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.

[robin_heijt]

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

[Gysbert_Wassenaar]

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

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