Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

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!!

3 Replies
Highlighted
Partner
Partner

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

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')

Naamloos.png

Hope this helps you.

Kind regards,

Ronald

Highlighted
MVP
MVP

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

Highlighted
Contributor III
Contributor III

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

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!!