Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist III
Partner - Specialist III

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.

View solution in original post

8 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

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

Not applicable
Author

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.

yavoro
Partner - Contributor III
Partner - Contributor III

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

Y.A.
Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

hi simon,

userid : Admin

password: admin.

or

userid : test1

password : test1

Not applicable
Author

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
Specialist
Specialist

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
Partner - Specialist III
Partner - Specialist III

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.