topic Re: Section Access in QlikView

Section Access

Mon, 26 Jan 2026 18:19:17 GMT

Hi guys,

I am in dire need of help with section access. I have seen examples on how to go about creating the section access, as seen below.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, 1, 1

USER, 2, 2

USER, 3, 3

];

How should I go about scripting if I would like to retrieve the User_type - which is values 2, for users and 3 for admins, User_name - to login and User_pwd - to login. All of which is retrieved from MySQL.

Btw, I am a total newbie to QlikView. Just started this as I thought it would be good for my business. Please do help me.

Thanks

Wayne.

Re: Section Access

ecolomer — Sun, 17 Aug 2014 14:39:43 GMT

You have two function to retrieve user:

QV User: QVuser( )

Windows User: OSuser()

For QlikView user is QVuser()

Re: Section Access

Sun, 17 Aug 2014 15:15:07 GMT

Sorry, I don't quite understand. Can I link the User_name from the database to be a QV User?

Re: Section Access

ecolomer — Sun, 17 Aug 2014 15:27:04 GMT

sorry, I had not understood

Re: Section Access

Sun, 17 Aug 2014 15:42:05 GMT

Hi,

You mean what you want to know QV can get the user id and password from MYSQL ?

WanKi,

Re: Section Access

Sun, 17 Aug 2014 17:42:11 GMT

Can you be more specific and give some sample data.

Re: Section Access

ashfaq_haseeb — Mon, 18 Aug 2014 09:05:13 GMT

Hi,

I think you have to retrieve information from database and Qlikview inline tables

and create and store a complete security table in your qvd after applying all transformations that you requires.

Then use this qvd and apply section access make sure to load this qvd unoptimized.

Regards

ASHFAQ