Hi Raju,
“Initial Data Reduction”
A reduction field can be added to control access to data for each individual user. The value in the reduction field is used to match against another field in the application with same name. If a match is found, the data will be reduced for the field and pre- sented to the user. The result will be the same as if this field was selected in the appli- cation and all none associated fields would be reduced.
“Strict Exclusion”
Access to the document will be denied whenever the field values in the section access reduction fields lack matches in their corresponding section application field. Having this option unselected will mean that if QlikView can’t find a match to reduce data, all data in the document will be visible on USER level. However, ADMIN will always be able to see all data, regardless of the reduction. Best practice is to use strict exclusion to avoid unwanted access to the QlikView document.
