Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Dalton_Ruer
Support
Support

Section Access using a Database

Ever felt a little let down when trying to implement Section Access and all of the examples focus solely on INLINE statements?

Ever wish for once you could see an example that was built using a database?

Well my friends search no longer your help has arrived. In this brief 5:30 video I demonstrate how to utilize a database to source your security reductions. Since we are going to be using SQL anyway we might as well do something slick like a UNION statement to build all of the necessary rows for accounts that will need "all" of the values. That way you don't have to actually worry about maintaining those values as your system grows. You gotta love that.

What's that you say? You don't have time to watch the video and just want to get the script code to do it. No problem, here you go:

SECTION ACCESS;

LIB CONNECT TO 'Security Database (qtsel_drr)';

AUTHORIZATION:

LOAD "ACCESS",

    "USERID",

    SPECIALTY;

SQL SELECT TOP 1000 [ACCESS]

      ,[USERID]

      ,[SPECIALTY]

  FROM [QlikView_DemoData].[dbo].[SecurityTestValues]

UNION ALL

select 'USER', 'INTERNAL\SA_SCHEDULER', SPECIALTY

from [QlikView_DemoData].[dbo].Specialties;

SECTION APPLICATION;

For that 1 person out there tempted to simply take my code and run it ... don't do that. You need to use your own database connection, your own database, your own table(s) and your own data.

I would love to know if this kind of thing is helpful for you.

2 Replies
oknotsen
Master III
Master III

To bad this is hidden in a blog. It could be a great more general document for all Sense users.

Thanks for sharing.

May you live in interesting times!
Dalton_Ruer
Support
Support
Author

Glad you liked it.