Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fatihsahin
Partner - Contributor
Partner - Contributor

Section access exclude values

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

1 Reply
sinanozdemir
Specialist III
Specialist III

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":

Capture.PNG

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

Capture.PNG

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

Capture.PNG

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

Capture.PNG

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

Capture.PNG

Hope this helps.