Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

Reducing data with Section Access

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!

1 Solution

Accepted Solutions
deepakk
Valued Contributor III

Reducing data with Section Access

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.

8 Replies
Highlighted
deepakk
Valued Contributor III

Reducing data with Section Access

hi,

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

Not applicable

Reducing data with Section Access

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.

Partner
Partner

Reducing data with Section Access

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

Not applicable

Reducing data with Section Access

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!

deepakk
Valued Contributor III

Reducing data with Section Access

hi simon,

userid : Admin

password: admin.

or

userid : test1

password : test1

Not applicable

Reducing data with Section Access

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?

pat_agen
Valued Contributor

Reducing data with Section Access

Simon,

you are almost there.

The star 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.

deepakk
Valued Contributor III

Reducing data with Section Access

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.