section access not working in qlik sense

[arulsettu]

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

[MK_QSL]

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;

[Chanty4u]

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;

[tresesco]

Could you share a sample qvf with representative data?

[arulsettu]

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

[arulsettu]

not allowed to share data

[Levi_Turner]

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:

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:

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:

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