Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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$);

20 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Pleasure.