Data level security in QlikView

[#1]

Hi All,

I have request to implement data level security in Qlikview as below. The Dashbaord has many reports at country level,subregion level and region level.

Lets say below table is the geography used in the dashboard. The security should work like this.

1. Users should be able to see only the countries data that they have access to. - This can be done using section access.

2. If a User has access to all the countries of a subregion then only he should see all the country level reports as well as those subregion level reports.

for Ex: If user has access to C1,C2,C3,C9,C10, then he should see respective country reports along with Subregion report of S1 as C1,C,C3 belons to S1 and he has access to all 3 countries but he should not see subregion S3 report because he has access only to 2 countries of that subregion.

3. If a User has access to all the countries of a subregion and all the subregions of a region then he should all the country reports and the respective subregion and region reports.

How to implement such an access restriction in Qlikview.

Country	SubRegion	Region
C1	S1	R1
C2	S1	R1
C3	S1	R1
C4	S2	R1
C5	S2	R1
C6	S3	R2
C7	S3	R2
C8	S3	R2
C9	S3	R2
C10	S3	R2
C11	S3	R2
C12	S3	R2
C13	S4	R2
C14	S4	R2

Thanks,

Shruthi Reddy

[tresesco]

I guess if you use section access simultenously on multiple fields (here Country, Subregion and Region), it would work fine for your scenario. Did you try implementing it? Any issues you faced?

[marcus_sommer]

It looked that you want to combine datalevel-related section access with a sheet/report/object-related restriction which are more an usability-feature then real data-restrictions. This meant it might be possible to use rather a count-condition to show or hide sheets/reports/objects maybe in a way like this: count(distinct Country) = $(vMaxCountSubRegion). But there are also section access variants possible - here you find many informations and examples about Section Access.

- Marcus