topic Re: Fields reduction in list boxes-Section Access in QlikView

Fields reduction in list boxes-Section Access

Tue, 08 Jan 2013 09:52:13 GMT

Hi All,

I am using list boxes in a sheet to display various measures.Can the fields in the list boxes can be restricted depending on the user login using section access.Please help me to sort out this problem

Thanks in advance

Re: Fields reduction in list boxes-Section Access

Tue, 08 Jan 2013 10:16:05 GMT

Is this type of reduction of data possible?

Please Reply Fast

Re: Fields reduction in list boxes-Section Access

adamwilson — Tue, 08 Jan 2013 10:17:00 GMT

This is straight from the reference manual, it shows exactly how to hide fields and hide rows, hope it helps:

Dynamic Data Reduction

First of all, fields (columns) can be hidden by the use of the system field OMIT.

Secondly, records (rows) can be hidden by linking the Section Access data with the real data: The selection

of values to be shown/excluded is controlled by means of having one or more fields with common names in

section access and section application. After user login QlikView will attempt to copy the selections in

fields in section access to any fields in section application with exactly the same field names (the field

names must be written in UPPER CASE). After the selections have been made, QlikView will permanently

hide all data excluded by these selections from the user.

In order for this procedure to take place, the option Initial Data Reduction Based on Section Access on the

Document Properties: Opening page must be selected. If this feature is used in documents that are to be distributed

by other means than via QlikView Server, the option Prohibit Binary Load on the same page of

the Document Properties must be selected in order to maintain data protection.

Note!

Example:

section access;

load * inline [

ACCESS, USERID,REDUCTION, OMIT

ADMIN, ADMIN,*,

USER, A,1

USER, B, 2,NUM

USER, C, 3, ALPHA

];

section application;

T1:

load *,

NUM AS REDUCTION;

load

Chr( RecNo()+ord(‘A’)-1) AS ALPHA,

RechNo() AS NUM

AUTOGENERATE 3;

The field REDUCTION (upper case) now exists in both section access and section application (all field

values are also upper case). The two fields would normally be totally different and separated, but if the Initial

Data Reduction Based on Section Access option has been selected, they will link and reduce the

number of records displayed to the user.

The field OMIT in section access defines the fields that should be hidden from the user.

The result will be as follows:

User A can see all fields, but only those records connected to REDUCTION=1.

User B can see all fields except NUM, and only those records connected to REDUCTION=2.

User C can see all fields except ALPHA, and only those records connected to REDUCTION=3.

Re: Fields reduction in list boxes-Section Access

Tue, 08 Jan 2013 10:36:21 GMT

Thanks Adam,

It was helpful. But can i reduce the data present in the list boxes using OMIT depending on the user.If so how can i do that?

Re: Fields reduction in list boxes-Section Access

adamwilson — Tue, 08 Jan 2013 10:46:05 GMT

OMIT hides the column from the user.

If you just want to show certain values within a field you have to define this within the section access. Look at the field REDUCTION in the example.

Re: Fields reduction in list boxes-Section Access

khadeer — Tue, 08 Jan 2013 10:47:52 GMT

U can restrict in data, sheet n document level

PFA. It will help u

Re: Fields reduction in list boxes-Section Access

Fri, 21 Feb 2014 16:22:16 GMT

How do you not reduce values in the data?

I currently have a document with Section Access and on the front-end I am suppose to see all values displayed in the listboxes in the document. I am not seeing all the values but a reduced list. I already know that due to not being data available for the values, it will not be available but still the values should be present and should be grayed out. This is not occuring.

Any suggestions on how to resolve this issue?

Re: Fields reduction in list boxes-Section Access

stevedark — Fri, 21 Feb 2014 16:29:24 GMT

Section Access will remove the values completely from the user - this is 99.9% of the time what you will want to do. What you are describing is like you want to apply a selection on a user opening the document that you then lock that selection.

I wouldn't advise this approach.