Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sweens78
Contributor

Section Access-accessing more than 1 category

Hi folks I have the below section access, if I want a user to access more than one category for example two hospitals in stead of one what would be the code.

I tried 1,2 but doesn't seem to work

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, HOSPITALID 
ADMIN, domain\joebloggs,*    // where * is access to all hospitals
USER, domain2\janebloggs, 1  //where 1 is the ID key of hospital one, 2 would be hospital 2 etc (want to add access to another hospital so is it 1,2?)
]
;

Thanks

Martin

1 Reply
chrismarlow
Contributor III

Re: Section Access-accessing more than 1 category

I think you just add a new line. There is a suggestion for a neater/shorter way here if you end up with too many values;


Multiple values in Section Access


Section Access;
LOAD * INLINE [
ACCESS, NTNAME, HOSPITALID 
ADMIN, domain\joebloggs,*    // where * is access to all hospitals
USER, domain2\janebloggs, 1  //

USER, domain2\janebloggs, 2
]
;


Regards,

Chris.

Community Browser