Password to Protect Sheet

[Anonymous]

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

[#2]

Hello,

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

QlikView Section Access Examples

[simospa]

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.

S.

[krishna20 · Accepted solution]

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