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.
