Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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