Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jessica_webb
Creator III
Creator III

Section access - data reduction

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

5 Replies
qlikview979
Specialist
Specialist

Hi

hope this is help full to you

application login issue?

jessica_webb
Creator III
Creator III
Author

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

Anonymous
Not applicable

prieper
Master II
Master II

Think that NAME-field has to carry capitals only.

Peter

Anonymous
Not applicable

  • 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.