Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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 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/>
Is this a typo, resource.name != "
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.
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/>
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!
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/>