Restricting user access per sheet level

[TingtingLiu]

I'm trying to restrict the user access to specific sheets, and I tried to create the security rule like the screenshot shows, but it doesn't work.

And I also tried to following the instruction from Sheet or App Object Level Security Qlik Sense - Qlik Community - 1485114, but it also not works.

Is there any suggestion can be provided to get it done? Thank you.

[BIAKS]

You can do it like below with custom properties, create new '@Sheet_Level' for each sheet you want to give access and be sure they are the exact same text with the sheet name:

[BIAKS]

you can also use below code for app level access by giving the app and the user same '@App_Level' custom properties:

[BIAKS]

If you dont want to manually add all sheets for a user you can also add below code after

'resource.name = user.@Sheet_Level'  and make the user's '@Sheet_Level' same as '@App_Level' and they will see all the sheet in the app:

or resource.app.@App_Level = user.@Sheet_Level

[TingtingLiu]

Thank you for the suggestion.

I tried to use the custom properties, and create the security rule like below, but the user not able to see the App, is anything I did wrong?

[BIAKS]

can you change 'App_*' to 'App*' and try again?

[TingtingLiu]

It's same, user cannot see the App

[BIAKS]

Does user see the stream?

[TingtingLiu]

No, the stream is not able to see by the user. so it's the problem? Any suggestion on it?

[BIAKS]

did you setup a stream level security rule? If not, you can do something like below: