Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to implement security on Tab level. I searched the forum and found an exmple here http://community.qlik.com/thread/38348
Actually, this method works well. But the issue is I want to use excel sheet to reload the Control table, instead of INLINE load, since we have many records to maintain.After the application is reloaded and distributed through PUBLISHER, I can not open this application from Access Point. Here is the security code I used in this application.
It is urgent to solve this problem. I really appreciate your help.
1. With INLINE load, it works after Publisher
Section Access;
LOAD
ACCESS,
NTNAME
FROM
F:\...\Security.xls
(biff, embedded labels, table is Sheet4$);
Section Application;
Control :
LOAD * INLINE [
NTNAME, Tab
USER1, Y
USER2,
];
2. With excel sheet load, it failed to open a file after Publisher
Section Access;
LOAD
ACCESS,
NTNAME
FROM
F:\...\Security.xls
(biff, embedded labels, table is Sheet4$);
Section Application;
Control :
LOAD NTNAME,
Tab
FROM
F:\...\Security.xls
(biff, embedded labels, table is Sheet4$);
Pleasure.