Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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