topic Section Access in QlikView

Section Access

Mon, 26 Jan 2026 18:19:17 GMT

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??

Carlos_Reyes — Thu, 23 Jan 2014 17:24:28 GMT

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

];

Thu, 23 Jan 2014 17:24:54 GMT

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:

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

Hope it helps

Thanks