Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello got a QVF file named Finance P&L Dashboards
in this file I got a base sheet named DB_TIMES
I want to hide this sheet temporarily for all users
I created the below security rule:
but I'm still able to see the sheet if I open the dashboard from the hub
Presumably, there's another rule (perhaps one of the default rules) that allows access to this sheet? You can't actually create exclusion rules, only inclusion rules, so if this rule includes every sheet except one and that one is still showing, a different rule is most likely to be at play.
Hi,
To add to @Or
You can see the rule called "Stream" (The user should see the resource if he/she has read access to the stream it is published to)
But a simple way to achive this is the Show/Hide condition in the sheet.
But a simple way to achive this is the Show/Hide condition in the sheet.
This does not act as security. Users with the right to duplicate / create sheets will be able to access the hidden sheet by making a copy of it.
so how can I hide this sheet from the users using a security rule?
You right ^^
It depending on risk you can take. Changing security rule can be tricky 😐
Another solution can be to unpublish and unapprove sheet. The sheet still exist but only the owner can see it.
I have found this
https://community.qlik.com/t5/New-to-Qlik-Sense/Sheet-level-Section-Access-in-Qlik-Sense/td-p/789067
You will need to find the security rule(s) that enable access to sheets and disable them. I'd suggest you be careful about this and do it in a test environment first to make sure you aren't breaking anything important.
I think the default rule in question is covered here, section 4.1:
Several discussions point to this article which is unclear
and it is about giving access to stream
anyways it seems this is a very vague / complicated issue
Perhaps, but then again, a security rule hiding a single sheet is a pretty obscure issue, so it stands to reason there's no clear and easy way to do it a the click of a button. You can use show/hide conditions as suggested by @Aurelien_Martinez if you want a simple approach.