topic Reducing data with Section Access in QlikView

Reducing data with Section Access

Wed, 30 Mar 2011 23:12:01 GMT

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!

Reducing data with Section Access

deepakk — Thu, 31 Mar 2011 04:18:32 GMT

hi,

I have attach a sample Section Access file. I hope it hellps you out.

Reducing data with Section Access

Thu, 31 Mar 2011 16:19:06 GMT

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.

Reducing data with Section Access

yavoro — Thu, 31 Mar 2011 16:26:50 GMT

Read Dynamic Data Reduction paragraph in Qlikview Reference Manual.

There is a good example how to do it. It did work for me.

Regards

Reducing data with Section Access

Thu, 31 Mar 2011 17:22:08 GMT

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!

Reducing data with Section Access

deepakk — Thu, 31 Mar 2011 19:26:28 GMT

hi simon,

userid : Admin

password: admin.

userid : test1

password : test1

Reducing data with Section Access

Thu, 31 Mar 2011 19:56:41 GMT

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?

Reducing data with Section Access

pat_agen — Thu, 31 Mar 2011 20:18:35 GMT

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.

Reducing data with Section Access

deepakk — Fri, 01 Apr 2011 03:00:12 GMT

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.