Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guptanupur
New Contributor II

How to add two values in reduction section while applying row level security ?

HI ,

now suppose I want to assign 2 values to one user id , for eg

Section Access;


LOAD * INLINE [

ACCESS, USERID, HOSPITAL

ADMIN,QLIK-SENSE\Admin,*

USER,QLIK-SENSE\xxx,ABC

USER,QLIK-SENSE\yyy,DEF

USER,QLIK-SENSE\zzz,GHI


If I want to assign both  (GHI and JKL) hospital value  to user zzz

How to write in script level ?

1 Solution

Accepted Solutions
devyanshu_gupta
New Contributor III

Re: How to add two values in reduction section while applying row level security ?

Hi,

You can add another line with value JKL

Try this

LOAD * INLINE [

ACCESS, USERID, HOSPITAL

ADMIN,QLIK-SENSE\Admin,*

USER,QLIK-SENSE\xxx,ABC

USER,QLIK-SENSE\yyy,DEF

USER,QLIK-SENSE\zzz,GHI

USER,QLIK-SENSE\zzz,JKL

]


Regards,

Devyanshu

1 Reply
devyanshu_gupta
New Contributor III

Re: How to add two values in reduction section while applying row level security ?

Hi,

You can add another line with value JKL

Try this

LOAD * INLINE [

ACCESS, USERID, HOSPITAL

ADMIN,QLIK-SENSE\Admin,*

USER,QLIK-SENSE\xxx,ABC

USER,QLIK-SENSE\yyy,DEF

USER,QLIK-SENSE\zzz,GHI

USER,QLIK-SENSE\zzz,JKL

]


Regards,

Devyanshu