Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning everyone,
I have done some research on this subject but could not find a solution. I need some help.
We have an app called Invoices, there are several sheets in this app.
I would like to deactivate a few sheets, so that our users can not see it anymore.
We have too many users to individually remove access.
Any other suggestions.? We are using Qlik Sense Enterprise
If you only have a small number of admin users you could use the match function to include only those users who are admin in the show condition. For example Match(Osuser(),'user 1','user 2','User 3') replacing user with your usernames which are generally in the format of domain/firstname.secondname.
Because our IT controls the user access and we also have so many users and admin users, I have chosen this way to deactivate a sheet in an app.
Easiest way to hide a sheet or deactivate it.
Make sure you are the owner of that app. Right click on the sheet you would like to hide or deactivate. Click on unapproved, right click again and unpublish.
It might be possible to revoke the access to the sheet from all users in the QMC. If that is the case it would be the easiest and cleanest approach.
Alternatively you can set the calculation condition of the sheet to False(). This is only a workaround. The sheet will still show up when the user is editing sheets.
Lastly you could replace your app with a copy with the sheets removed until you find a better solution.
Hi
Simply edit each sheet you wish to hide in turn and in sheet properties there is a show condition. Type =0 in the show condition and the sheet will be hidden. Hope this helps.
Kindest regards
Brian
@TheresaB_4 Do you want to disable only for few users or all users including Admin's?
I would like to disable it for normal users but not admin. Only users that are allowed to view sheet not edit sheets.
I have tried to edit the sheet properties and now the sheet disappeared.
how is the security setup in your environment? This is one way.
But, you have mentioned that after you edit the sheet, the sheet gone? this is not able to follow if I am understanding correct.
If you only have a small number of admin users you could use the match function to include only those users who are admin in the show condition. For example Match(Osuser(),'user 1','user 2','User 3') replacing user with your usernames which are generally in the format of domain/firstname.secondname.
Because our IT controls the user access and we also have so many users and admin users, I have chosen this way to deactivate a sheet in an app.
Easiest way to hide a sheet or deactivate it.
Make sure you are the owner of that app. Right click on the sheet you would like to hide or deactivate. Click on unapproved, right click again and unpublish.
i have many sheet to
in order to display just a few i create a filter in this case society
if the select one of this, adding a second condition , in the sheet
making a match function, so in this case if the society not match with 3000 it will display the sheet
but if you dont want use a filter u cant just put another condition in order to hide the sheet, and this sheet will never visible after the app is publish, only on developer mode
and this work even when they open the app