Section Access - Data Reduction

[#1]

Hi All,

In my application the section access part has been added by loading two fields Username and Password from the SQL database. That was running fine. But now there is a need to select a field value  i.e. to apply a filter for a particular User.

I have added the trigger Select in Field for that particular field and the value as  IF( QVUser()='A','apple') . But its not working.

It will be great if I can get some help on this.

[#2]

Hi ,

     can you please give more info on this

   what my understanding here you applied section access after that once you deployed this in to the server if any user open this document t has to select his NT name in the list box is that my understanding correct?

[Anonymous]

when you enter osuser() in a textobject, what is the outcome?

in your example the domainis missing

osuser() Returns Domain\userA

[Anonymous]

Instead of using triggrs, it is better to use data reduction based on section access.  See example from "help" where the DEPT field is used for data reduction:

section access;
load * inline
[UserID,DEPT,Access
John,FINANCE,Admin
ANN,IS,Admin
Peter,SALES,User
Ben,TECH,User ] ;

section application;
star is *;

load * inline
[DEPT,CostCenter
FINANCE,*
IS,5020
SALES,5030
TECH,5040 ] ;

[Colin-Albert]

This document has examples on setting up Section Access and data reduction. There is no need to use triggers.

Introduction to Section Access

[Colin-Albert]

Remember to create a safe copy of your document before applying section access controls as you can lock yourself out of your document permanently.

[Kushal_Chawda]

Instead of creating condition on front end, You can reduce the data in Sanction access itself.

You can create saction acccess metrics as below

Access,  UserID,  Password,  Fruit

ADMIN,  ADMIN,  ADMIN,  *

USER,  JOHN,  JOHN,  APPLE

USER,  MARY,  MARY,  APPLE

USER,  PETER,  PETER, ALL ];

See the below link

https://community.qlik.com/docs/DOC-5917