section access

Thu, 20 Aug 2015 16:23:55 GMT

'initial selection based on section access'-what is the meaning of this statement exactly.

while creating section access if i click on this what it is going to do.

Re: section access

Gysbert_Wassenaar — Thu, 20 Aug 2015 16:55:28 GMT

From the help file:

Dynamic Data Reduction

QlikView and QlikView Server support a feature by which some of the data in a document can be hidden from the user based on the section access login.

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.

Re: section access

kkkumar82 — Thu, 20 Aug 2015 17:03:44 GMT

Adding to Gysbert,

There is one more option below what you have asked janith i.e, strict exclusion which doesn't show anything when wrong username and password is given , if this option is not used and the login credentials are wrong QV will show up all the data.

Gysbert correct me if I am wrong.

Thanks

Kiran Kumar

topic Re: section access in QlikView

section access

Re: section access

Dynamic Data Reduction

Re: section access