Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access with Qliksence and SQL not working

Hi Fellow Qlikers,

I'm trying to implement a robust section access NOT using inline code but via SQL. I've already seen Dork's video but doesn't work for me.

What I  have is as follows - note the bridge file contains a compound access key and works a Qlik filter without any security. The accessID  key  joins to the master Fact table and the Access to the Authorisation table via AuthorisationBridge:

AuthorisationBridge:

LOAD

  AccessID,

  [ACCESSKEY]

FROM [$(vQVDPath)AuthorisationBridge.qvd](qvd);    

SECTION ACCESS;

LOAD

     ACCESS,

     USERID,

     ACCESSKEY 

FROM [$(vQVDPath)Authorisation.qvd](qvd);  

But all I get is locked out and have to open without data to get back in.  I have also tried using SQL directly  i.e.

LIB CONNECT TO '2012 Security';

LOAD

     UPPER(ACCESS) as ACCESS,

     USERID,

     ACCESSKEY; 

SQL SELECT  *     

FROM [2012_Security].[dbo].[QlikSectionAccess];

But no access even  tried loading  this with my Dimensions then using a resident load to reload under section access. With a few million rows on the bridge table  using an inline table is just NOT an option here.

Any help would be  very much appreciated.

Thanks & Kind Regards

Mike

0 Replies