Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hello,
I think this will help you. You need to add a 'Section Access' in the Script
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.
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