topic Re: Password to Protect Sheet in QlikView

Password to Protect Sheet

Anonymous — Tue, 20 Oct 2015 08:13:50 GMT

How can i make a username and password to access the sheets in qlikview, Like Villanova School Demo

i put the demo in attachment..

UserName: OFFICE

Password: OFFICE

Re: Password to Protect Sheet

Tue, 20 Oct 2015 08:41:31 GMT

Hello,

I think this will help you. You need to add a 'Section Access' in the Script

QlikView Section Access Examples

Re: Password to Protect Sheet

simospa — Tue, 20 Oct 2015 08:41:39 GMT

Hi,

take a look here: Sheet level access

Using section access is the best way.

You could use two variables and insert conditional Show sheet in a way like this:

Actual:

SheetGroup<>3

To be:

SheetGroup<>3 and (vMyUser='AAA' OR vMyPwd='BBB')

on the onOpen of the .qvw (Settings --> Document Properties --> Triggers) you must set the two variables to blank.

But this solution is less secure and can be easily bypassed by user.

Re: Password to Protect Sheet

krishna20 — Tue, 20 Oct 2015 10:24:12 GMT

Hi,

Please find the attached excel.

Hi,

Please find the below script as well as attached Excel. Hope it helps.

Section Access;

Star is *;

LOAD ACCESS,

NTNAME,

COMP_CODE,

DEPT_CODE,

SH01,

SH02,

SH03,

SH04,

SH05

FROM

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

LOAD //ACCESS,

NTNAME,

//COMP_CODE,

//DEPT_CODE,

SH01,

SH02,

SH03,

SH04,

SH05

FROM

(ooxml, embedded labels, table is Sheet1);

Goto sheet Properties-> In general -> Select Conditional -> Give SHEET ID=1 eg; SH02=1