Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pieterman
Partner - Contributor
Partner - 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)

 

;

 

0 Replies