Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvvvvv
Creator
Creator

Section access multiple selection

How to allow user access multiple value in the same field??

For example, how to allow userA can view data about school A ,B,C while there are A-E school?

Load * inline[

ACCESS,USERID,SCH

ADMIN,ADMIN,*

USER,userA,A|B|C

]?

 

user A|B|C or A&B&C or anything else?

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

There could be many ways. For now, I can use 2 ways

Scenario:(1)

Load *, SubField(SCH, '|') as SCH inline[

ACCESS,USERID,SCH

ADMIN,ADMIN,*

USER,userA,A|B|C

];

Scenario:(2)

Load * inline[

ACCESS,USERID,SCH

ADMIN,ADMIN,*

USER,userA,A

USER,userA,B

USER,userA,C

];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

3 Replies
Anil_Babu_Samineni

There could be many ways. For now, I can use 2 ways

Scenario:(1)

Load *, SubField(SCH, '|') as SCH inline[

ACCESS,USERID,SCH

ADMIN,ADMIN,*

USER,userA,A|B|C

];

Scenario:(2)

Load * inline[

ACCESS,USERID,SCH

ADMIN,ADMIN,*

USER,userA,A

USER,userA,B

USER,userA,C

];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vvvvvvvvvv
Creator
Creator
Author

It works.But why user with ACESS cannot view the data but only admin with ACCESS can view the data>?

Anil_Babu_Samineni

Read this https://community.qlik.com/t5/QlikView-App-Development/Admin-vs-User/m-p/1177786

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful