Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
robin_heijt
Creator
Creator

Section Access based on an internal QS table.

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.

 

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

robin_heijt
Creator
Creator
Author

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;

talk is cheap, supply exceeds demand