Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
];
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
];
It works.But why user with ACESS cannot view the data but only admin with ACCESS can view the data>?
Read this https://community.qlik.com/t5/QlikView-App-Development/Admin-vs-User/m-p/1177786