Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
newhere2014
Contributor II
Contributor II

Tab level security issue

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$);

Labels (1)
20 Replies
Jason_Michaelides
Partner - Master II
Partner - Master II

Pleasure.