Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a dashboard where one group of users can only see the previous year, but another group can see all years (I have a field called YEAR that is an integer). I specifically have to use Section Access. Both groups have USER level access to the document.
Is there a way to do this using Section Access?
Thanks!
hi simon,
I didnt get you. Y do u require Strict Exclusion. ?
You jsut need to create to tables.
Table1
Group Year
A, (blank) for all years
B, 2011
C,2010
And link this group to user table like
User Group
simon A
Deepak B and so on.
hi,
I have attach a sample Section Access file. I hope it hellps you out.
Hey Deepak,
Thanks for the response. Can you tell me the userID/password that I can use to access the document?
Is there a hidden script section? If so, can you post the password to that as well?
Thanks for taking the time to answer.
Hi
Read Dynamic Data Reduction paragraph in Qlikview Reference Manual.
There is a good example how to do it. It did work for me.
Regards
Hi Yavor, thanks for responding!
The example in the QlikView Manual does give a good example for simple situations, but I don't think it works in this case. Do you have an example that shows how to solve my specific simple problem?
Here is the issue I am trying to solve. Do you know how to restrict access (with data reduction) to a field for one user but grant full access to that field for another user?
I have tried using '*', but that only grants access to all of the field values for the listed in section access. Does anyone know how to solve this problem?
Thanks!
hi simon,
userid : Admin
password: admin.
or
userid : test1
password : test1
Thanks Deepak!
It does work as desired, but it is not using Strict Exclusion. Do you know how to make it work with Strict Exclusion?
Simon,
you are almost there.
The star represents all the values you have listed in section access in your security field (in your case the field YEAR).
As you have only specifed the years the people with restricted access can see even the super users who "can" see everything are only seeing those years.
The workaround is to load into the YEAR field, in section access, all the values of YEAR that are in your document. Then the the "*" will give your super users access to everything.
This works with strict exclusion.
Hope this is clear.
hi simon,
I didnt get you. Y do u require Strict Exclusion. ?
You jsut need to create to tables.
Table1
Group Year
A, (blank) for all years
B, 2011
C,2010
And link this group to user table like
User Group
simon A
Deepak B and so on.