Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arulsettu
Honored Contributor III

section access not working in qlik sense

hi i am doing section access in sense server

like this

section access;

load * inline [

ACCESS, USERID, COMPANY_CODE

USER, DOMAIN\arul.settu, 001

];

Section Application;

it worked once. after i tried to include more company for same user not working.

any ideas?

Thanks

6 Replies

Re: section access not working in qlik sense

try

section access;

load * inline [

ACCESS, NTNAME, COMPANY_CODE

USER, DOMAIN\arul.settu, 001

];

Section Application;

Also not sure but you can make

section access;

load ACCESS, UPPER(NTNAME), COMPANY_CODE inline [

ACCESS, NTNAME, COMPANY_CODE

USER, DOMAIN\arul.settu, 001

];

Section Application;

sureshqv
Esteemed Contributor III

Re: section access not working in qlik sense

try lik below

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION, OMIT

USER, AD_DOMAIN\ADMIN,*,

USER, AD_DOMAIN\A,1,

USER, AD_DOMAIN\B, 2,NUM

USER, AD_DOMAIN\C, 3, ALPHA

USER, INTERNAL\SA_SCHEDULER,*,

];

section application;

MVP
MVP

Re: section access not working in qlik sense

Could you share a sample qvf with representative data?

arulsettu
Honored Contributor III

Re: section access not working in qlik sense

bro i tried both but not working. it showing all company details

arulsettu
Honored Contributor III

Re: section access not working in qlik sense

not allowed to share data

Employee
Employee

Re: section access not working in qlik sense

On my end:

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION,

USER, DOMAIN\Me,*

USER, DOMAIN\User2, 2

USER, DOMAIN\User3, 3

USER, INTERNAL\SA_SCHEDULER,*

];

section application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

Chr( RecNo()+ord('A')-1) AS ALPHA,

RecNo() AS NUM

AUTOGENERATE 3;

Produces:

wLd8xij.png

This:

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION,

USER, DOMAIN\Me,1

USER, DOMAIN\User2, 2

USER, DOMAIN\User3, 3

USER, INTERNAL\SA_SCHEDULER,*

];

section application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

Chr( RecNo()+ord('A')-1) AS ALPHA,

RecNo() AS NUM

AUTOGENERATE 3;

Produces:

1.png

And this:

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION,

USER, DOMAIN\Me,1

USER, DOMAIN\Me,2

USER, DOMAIN\User2, 2

USER, DOMAIN\User3, 3

USER, INTERNAL\SA_SCHEDULER,*

];

section application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

Chr( RecNo()+ord('A')-1) AS ALPHA,

RecNo() AS NUM

AUTOGENERATE 3;

Produces:

1_and_2.png

So I am not quite seeing what you're describing.

Community Browser