Section access exclude values

fatihsahin — Mon, 03 Aug 2015 15:16:46 GMT

Hi,

lets say I have following fields:

Product Category

1 A

2 B

3 C

4 D

5 E

Now I have various users which can see everything but one user should not see Category D from Product 4. Everything else is again visible for this user.

How I can exclude this combination for a specific user?

Regards

Re: Section access exclude values

sinanozdemir — Mon, 03 Aug 2015 15:55:38 GMT

Hi Fatih,

You can accomplish this with section access script. I am also attaching qvw as well as screenshots of how to do:

First, make sure that in the document properties under opening tab, you check "Initial Data Reduction Based on Section Access" and "Prohibit Binary Load":

And then you need to create a section access script (everything is capitalized):

Also make sure that the columns that you want to restrict are also capitalized:

After all this, save the document, close and re-open it. It will ask you for password:

For user1, when I type the password, user1 cannot see Product 4 and Category 4:

Hope this helps.

topic Re: Section access exclude values in QlikView

Section access exclude values

Re: Section access exclude values