topic Re: restrict access to sheet in the script in QlikView

restrict access to sheet in the script

Wed, 07 Oct 2015 06:42:58 GMT

Hi,

In the attached app I have set up I want to build some security into it.

I have resricted access to the tab in question (cost) using a conditional show sheet on the sheet properties. Next and final step is restricting access to a tab in the script called 'cost'. I don't want peple in my team to see the detail in here.

Can someone please help in telling me how I can do this? Really not good with section access so apologies if this is really simple.

Chris

Re: restrict access to sheet in the script

avinashelite — Wed, 07 Oct 2015 07:01:31 GMT

Please check this threads:

Sheet level access

Section access on sheet level‌

Re: restrict access to sheet in the script

Anonymous — Wed, 07 Oct 2015 07:13:40 GMT

FOr security at front end use

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, GROUP

ADMIN, ADMIN, PASSWORD, *

USER, ABC, PASSWORD, 1

USER, XYZ, PASSWORD, 2

];

Section Application;

LOAD * Inline [

GROUP, SHEET1,SHEET2,SHEET3

1,1,0,1

2,0,1,1

];

and at properties of sheets use conditional show

example> at sheet 1 use if(sum(SHEET1)>0,1,0) and so on.

For scritp level security as you dont want others to check for Cost tab, then you can create hidden script and place it there.

Re: restrict access to sheet in the script

Wed, 07 Oct 2015 07:17:18 GMT

How do you create a hidden script?

Chris

Re: restrict access to sheet in the script

avinashelite — Wed, 07 Oct 2015 07:19:35 GMT

Go to edit script>file>hidden script

Re: restrict access to sheet in the script

Wed, 07 Oct 2015 07:21:18 GMT

Its greyed out...can't select it

Re: restrict access to sheet in the script

SreeniJD — Wed, 07 Oct 2015 07:40:46 GMT

Hi Chris,

It will be available in Edit Script-> File menu-> Create Hidden Script, It will open a popup window for requesting New Password and Confirm Password (to later unhide the script).

Create a new QVW and then see whether "Create Hidden Script" is still greyed out?

Sreeni

Re: restrict access to sheet in the script

avinashelite — Wed, 07 Oct 2015 07:51:15 GMT

You must login as the ADMIN to access it