Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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