Qlik Community

Qlik Sense App Development

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

pieterman
New Contributor

Simple sectionaccess not working

HI

I want to implement section access on a QS server environment (for row and columnlevel access for users)

Alas even the simplest version of this doesnot seem to work (see script below I myself as a user. But when I open the sheet I can see A and B (in the rows) and OM1 (as a column).

What I am doing wrong. Can you please advice me?

Erik

section access;

 

LOAD * inline [

 

ACCESS,USERID,KPI,OMIT

 

USER,xxx\xx,B,OM1

 

USER,INTERNAL\SA_SCHEDULER,*,

 

];

 

 

section application;

 

Load

 

if(log_TableName='edm.dbo.dim_kpi','A','B') as KPI,

 

Log_Duration as OM1,

 

*

 

From [lib://$(vLib)/QVDmeta_log.qvd] (qvd)

 

;