Discussion Board for collaboration on QlikView Security and Governance.
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??
Yes, you have to create a record for each combination of user and value in the Section Access table. Something like the next:
LOAD * INLINE [
ACCESS, NTNAME, FIELD1
USER, USER1, VALUE2
USER, USER1, VALUE3
USER, USER1, VALUE5
USER, USER2, VALUE2
USER, USER2, VALUE6
USER, USER3, VALUE1
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:
So it all depends on how that values are related in your Data Model tables.
Hope it helps