section access

Wed, 11 Dec 2013 09:54:44 GMT

I want to be able to pre-filter in Qlikview based on the user login and undestand that section access is the best way to achieve this.

I have changed the setting in the document setting to allow this.

Firstly Is exactly the same code used for the filtering option?

Secondly I can't quite get the code to work - i did briefly but then changed something to stop it working.

In my code below I the access is obviously the level of security to the user, the NT name is the login name, then the group is the group that I want to set up for the security (is this a valid column header?)

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, GROUP
ADMIN, AD\MAGINJ90, All
ADMIN, AD\MASONS92, All2
ADMIN, AD\WILDNJ, test 2
];

What is the syntax that needs to be used, ie does it need to be in single speech marks, in brackets, can it have a * after as with normal database queries, what if there are more than one?

Section Application;

LOAD * INLINE [

GROUP, CustomerId

All, 120
All2, (130)
All3, '140'
test, in(120,140)

];*

Any help would be greatly appreciated, I f i can get a simple version working inline i will then be able to set it up in tables myself.

Re: section access

salto — Wed, 11 Dec 2013 09:58:09 GMT

Hi,

In section Access, if all users are ADMIN they will have access to all the data. Set as ADMIN only the admins...

In Section Application,set the CustomerID as 130 instead of (130). If there is more than one you need to add a line for every customer:

Section Application;

LOAD * INLINE [

GROUP, CustomerId

All, 120
All2, 130
All3, 140
test, 120

test, 140

];*

Hope this helps.

topic section access in QlikView

section access

Re: section access