what is Strict Exclusion and why we use this one?

[#1]

I am new to qlikview ,so can you tell me what is Strict Exclusion and why we use this one?

[JonnyPoole]

Its adds a level of data security to the application.

Lets say your section access is written as follows.  If you had 'strict exclusion' disabled (unchecked), then user3 could see all the values of REGION.  If you had it enabled (checked) they could not even access the document because there is no explicit value in the table that they have access to.  It adds a requirement to be explicit with who can see which values.

--------------

Section Access;

LOAD * INLINE [

    ACCESS, USERID, REGION

    ADMIN, ADMIN,

    USER, USER1, NORTH AMERICA

    USER, USER2, *

    USER, USER3,   

];

Section Application;

----------------

[Peter_Cammaert]

If Strict Exclusion is disabled, all users that have a Section Access entry but do not have data linked to their Section Access entry (data reduction would reduce to nothing) would get access to the document and ALL data (= no data reduction in reality).

If Strict Exclusion is enabled, all users that have a Section Access entry but do not have data linked to their Section Access entry (data reduction would reduce to nothing) will be thrown out of the document (Access Denied)

Only useful/operational when "Initial Data Reduction based on section access" is activated.

[#4]

Hi,

If a user doesn't have access any data if he won't access even the document also if the strict exclussion checked.