topic Section Access - Data Reduction in QlikView

Section Access - Data Reduction

Mon, 03 Aug 2015 10:24:22 GMT

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.

Re: Section Access - Data Reduction

Mon, 03 Aug 2015 10:42:14 GMT

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?

Re: Section Access - Data Reduction

Anonymous — Mon, 03 Aug 2015 10:55:22 GMT

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

in your example the domainis missing

osuser() Returns Domain\userA

Re: Section Access - Data Reduction

Anonymous — Mon, 03 Aug 2015 11:05:13 GMT

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 ] ;

Re: Section Access - Data Reduction

Colin-Albert — Mon, 03 Aug 2015 11:12:26 GMT

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

Introduction to Section Access

Re: Section Access - Data Reduction

Colin-Albert — Mon, 03 Aug 2015 11:13:54 GMT

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

Re: Section Access - Data Reduction

Kushal_Chawda — Mon, 03 Aug 2015 11:14:04 GMT

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