Section Access : How to Restrict a User to see only 2 sheets in QlikView

[Anonymous]

Hello All,

I have a dashboard with 3 tabs. Sheet1, Sheet2 , Sheet3

I want to restrict two sheets for user "Ajay" & "RKT" and Admin see all sheets when he opens the dashboard from Access Point.

I attached .qvw & excel sheet for your reference.

Thanks in advance!!

[RonaldDoes]

Hi,

You can show sheets to specific users by adding them to the conditional show properties of the sheet.

• Open sheet properties (Settings -> Document Properties)
• Show sheet -> conditional: =If(Upper(OSUser())='Ajay', 'RKT', 'Admin')

Hope this helps you.

Kind regards,

Ronald

[tresesco]

Have a look here:

Section Access - Hide Sheet Level

Type of Security

[Anonymous]

Hi Tresesco & Ronald,

Thanks for your reply!!

Tresesco : When i login with admin , it opens the sheets but when i log into user's credentials , it doesn't take user'e login.

Thanks!!