Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Section Access

Is it possible to assign two values to the same user. I have a field with values [ value1, value2, value3.... value 10]

I want user1 to access value2,value3,value5 and user2 to have access to value2, value6 and user3 to have access to value1 etc. IS this possible??

2 Replies
carlos_reyes_qv
Valued Contributor

Re: Section Access

Yes, you have to create a record for each combination of user and value in the Section Access table. Something like the next:

[Section Access]:

LOAD * INLINE [

ACCESS, NTNAME, FIELD1

USER, USER1, VALUE2

USER, USER1, VALUE3

USER, USER1, VALUE5

USER, USER2, VALUE2

USER, USER2, VALUE6

USER, USER3, VALUE1

];

Not applicable

Re: Section Access

Hey Anitha,

If the table in your Data Model already has the relationship you mentioned built in then its possible. For example if the table looks like this:

UserField

User1

value2
User1value3
User1value5
User2value2
User2value6
User3value1

So it all depends on how that values are related in your Data Model tables.

Hope it helps

Thanks

AJ

Community Browser