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

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

vishsaggi — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

trdandamudi — Thu, 08 Sep 2016 01:59:03 GMT

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

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

vishsaggi — Thu, 08 Sep 2016 13:50:17 GMT

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

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

Anonymous — Fri, 09 Sep 2016 05:07:06 GMT

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?

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

trdandamudi — Fri, 09 Sep 2016 05:31:36 GMT

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

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

Anonymous — Fri, 09 Sep 2016 05:53:11 GMT

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

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

trdandamudi — Fri, 09 Sep 2016 06:00:08 GMT

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.

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

Anonymous — Fri, 09 Sep 2016 06:22:25 GMT

ok. try this

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

Anil_Babu_Samineni — Fri, 09 Sep 2016 06:28:37 GMT

Have you created FLAG for specific sheet and USER??

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

Fri, 09 Sep 2016 06:35:44 GMT

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

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

vishsaggi — Mon, 23 Oct 2017 21:52:04 GMT

I know this has been posted long time. I got some tips from your script and got it worked. Thank you.

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

trdandamudi — Thu, 26 Oct 2017 17:57:56 GMT

You are welcome....