topic Section access - data reduction in QlikView

Section access - data reduction

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

Getting very stuck on section access, so hoping someone can tell me where I'm going wrong!

Our clients log into their applications via QV Accesspoint, and can only see the documents that they have access to.

I would like to limit the data they see once they've logged in - I managed to get this working properly on an old document so I know it's possible, but can't recreate it (and no longer have access to old doc).

Basically, there is a field in the data called 'NAME' and our users login using their 'NAME'. I want the field 'NAME' to be filtered according to what they login as.

At the moment, in the script I have:

Section Access;

LOAD * inline [

ACCESS, USERID, NAME

USER, jessica.webb,*

USER, Super,*

USER, George,George

USER, Sam,Sam

USER, Dennis,Dennis

USER, Mark,Mark

USER, INTERNAL\SA_SCHEDULER,*

];

Section Application;

If I logon (jessica.webb) or 'Super', I would like us to be able to see everything with no data reduction. But if George logs on, he should only see data associated with 'George' in the name field.

At the moment, this isn't even slightly working. If I logon as 'George' via access point, it asks me to reenter username and password again when I click to open the document (I don't want our users to have to login twice), and then I can see everything anyway - i.e. the data reduction hasn't worked!

Help with this would be greatly appreciated,

Jess

Re: Section access - data reduction

qlikview979 — Mon, 15 May 2017 08:53:38 GMT

hope this is help full to you

application login issue?

Re: Section access - data reduction

jessica_webb — Mon, 15 May 2017 08:57:35 GMT

Hi Mahesh,

Thanks for the link. Unfortunately it seems to be solving a different problem to mine. I would like data reduction, not sheet access...

It also doesn't solve the problem of avoiding users having to login twice.

Thanks,
Jess

Re: Section access - data reduction

Anonymous — Mon, 15 May 2017 09:09:34 GMT

Have a look:

Re: Access point is asking some users to sign in twice. After they enter login credentials then click on the Report Modu…

Hope it helps!!

Re: Section access - data reduction

prieper — Mon, 15 May 2017 09:25:59 GMT

Think that NAME-field has to carry capitals only.

Peter

Re: Section access - data reduction

Anonymous — Mon, 15 May 2017 09:42:36 GMT

All fields in Section Access must be upper case. Hence, the reducing field must be in upper case also in the data. Use the Upper() function and name the fields in upper case.