Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
guptanupur
Contributor II
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
Partner
Partner

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

View solution in original post

1 Reply
devyanshu_gupta
Partner
Partner

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

View solution in original post