Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
vishsaggi
Esteemed Contributor III

Section Access: Restrict a user, to see only one sheet

Hello All,

I have a dashboard with 5 tabs. Sheet1, Sheet2, Sheet3, Sheet4, Sheet5.

I want to restrict one AD user named "Analyst1" to view only sheet3 and all other sheets should be hidden when he opens the dashboard from Access Point.

Any help much appreciated.

Thanks,
V.

1 Solution

Accepted Solutions
trdandamudi
Honored Contributor II

Re: Section Access: Restrict a user, to see only one sheet

I am attaching a file which I worked long back, I made you the admin for this dashboard. When you open the file it will ask for the password and type it as "vish".

There is a hidden script and to open that the password is "admin".

Basically when you open the file with your ID, you will see three tabs. when you login as "david" you will see only two tabs. Sheet1 was hidden for David and that is the reason you see two tabs for him. Hope this helps....

View solution in original post

11 Replies
trdandamudi
Honored Contributor II

Re: Section Access: Restrict a user, to see only one sheet

I am attaching a file which I worked long back, I made you the admin for this dashboard. When you open the file it will ask for the password and type it as "vish".

There is a hidden script and to open that the password is "admin".

Basically when you open the file with your ID, you will see three tabs. when you login as "david" you will see only two tabs. Sheet1 was hidden for David and that is the reason you see two tabs for him. Hope this helps....

View solution in original post

vishsaggi
Esteemed Contributor III

Re: Section Access: Restrict a user, to see only one sheet

Thanks Thirumala. Will try and get back if any questions. Appreciate you time.

lauracastagna
Contributor II

Re: Section Access: Restrict a user, to see only one sheet

Thanks Vish,

I wondered why I couldn't see your response in my link yesterday :-).  I didn't realise you were directing me to another question.

where you have nothing under the OMIT column.  does this mean the user can see everything?

trdandamudi
Honored Contributor II

Re: Section Access: Restrict a user, to see only one sheet

Laura,

Couple of hours back I did responded to your other thread with this link.

Under the OMIT column if there is nothing then the user can see everything. Please take a note for David I have 'SALES'. Meaning David will not see the column 'SALES'.

Hope this helps...

lauracastagna
Contributor II

Re: Section Access: Restrict a user, to see only one sheet

still not working.  can you please take a look at my .qvw file!

trdandamudi
Honored Contributor II

Re: Section Access: Restrict a user, to see only one sheet

I am not able to open the file and I am getting the below error:

Access denied to the Qlikview document

Also the file is too big, can you please make a small sample and post it so that, it will be easy to test it out.

lauracastagna
Contributor II

Re: Section Access: Restrict a user, to see only one sheet

ok.  try this

Re: Section Access: Restrict a user, to see only one sheet

Have you created FLAG for specific sheet and USER??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

Re: Section Access: Restrict a user, to see only one sheet

Hi Nagaraju,

section Access;

Load * inline  [

Access,UserID,Password,SHEETID

ADMIN,TEST1,TEST1,*

USER1,USER1,USER1,SH01

USER2,USER2,USER2,SH02

];

In document properties, select initial reduction based on section access

In general of your sheet tavb  check conditional  count( 'SH01')>1