Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.