Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sheet Security

I have seen other post on this topic and they are not correct and or misleading.  Is there currently away in Sense 3.1 to hide a sheet in an application so normal users cannot see it?  The read privileged would be only for a Root admin, just to keep it simple.

8 Replies
p_verkooijen
Partner - Specialist
Partner - Specialist

Take a look at reddys310 answer in Sheet level security qliksense

Replace the (resource.name = "Sheet1") with (resource.name != "<SheetID>")

Note: you can get the sheet ID from the the single configuration tab in the DEV-HUB

Replace the(user.name = "user1") with (user.name = "<UserID>")


This will actually restrict a user from viewing a particular sheet

kevincase
Creator II
Creator II

Sean,

Yes you can add sheet security.

What you want to do is create a rule that grants read access to a sheet where the name = your_sheet_name and user.roles="RootAdmin"

I would be reluctant to implement sheet security as I think it would require constant maintenance as your environment changes and/or sheet names change.  I also think people may be reluctant to answer and give you an exact rule as everyone's environments have different security rules implemented.

Something like this may work.  You just have to experiment a little.  In this example, it grants read access to the Performance Figures sheet only if your role is RootAdmin.

Hope this helps.

Kevin

Not applicable
Author

Not having much luck. Is there a default rule that allows access to sheets that may be interfering?

Sean Smith

Consultant

N27 W23957 Paul Road, Suite 100, Pewaukee, WI 53072

262.751.5193

sean.smith@solve100.com<mailto:sean.smith@solve100.com>

www.Solve100.com<http://www.solve100.com/>

Not applicable
Author

Is this a typo, resource.name != "

kevincase
Creator II
Creator II

Sean,

If you are a root admin, you my not be able to test the rule as this rule may override your new rule.  You would need a test user that you can connect with that does not have the root admin role.

Not applicable
Author

I do have another login that I am using for testing and that user can still see the sheet. Ant other thoughts? Have you been able to get this to work?

Sean Smith

Consultant

N27 W23957 Paul Road, Suite 100, Pewaukee, WI 53072

262.751.5193

sean.smith@solve100.com<mailto:sean.smith@solve100.com>

www.Solve100.com<http://www.solve100.com/>

kevincase
Creator II
Creator II

Sean,

I did not get it to work.  I would suggest opening a ticket with support.  If I have time on Monday, I'll give it another try.  I'm missing something and its late on a Friday!

Not applicable
Author

Totally understand thanks let me know

Sean Smith

Consultant

Solve

N27W23957 Paul Rd

Suite 100

Pewaukee, WI 53072

262.751.5193

www.Solve100.com<http://www.solve100.com/>