Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Password to Protect Sheet

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

1 Solution

Accepted Solutions
krishna20
Specialist II
Specialist II

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

View solution in original post

3 Replies
Not applicable
Author

Hello,

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

QlikView Section Access Examples

simospa
Partner - Specialist
Partner - Specialist

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
Specialist II
Specialist II

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