Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
Not applicable

Section Access- Reduce data for only some objects

Hi all!

My customer wants to use Section Access on their reports, but it isn't usual Section access.

I have the following structure:

data model.png

On example, we have 2 kind of users:

1) chief of department

2) manager of group

I should ruduce data by the following rules:

USER

Department

Group

chief of department1

Department1

*

chief of department2

Department2

*

chief of department3

Department3

*

managers of group1_1

Department1

Group1_1

managers of group1_2

Department1

Group1_2

managers of group1_3

Department1

Group1_3

managers of group2_1

Department2

Group2_1

managers of group2_2

Department2

Group2_2

managers of group2_3

Department2

Group2_3

managers of group3_1

Department3

Group3_1

...

...

...

But!! I have3 pivote tables on my reports, which shows us ranks:

1) Rank departments;

2) Rank groups;

3) Rank offices.

So,chief of department1 must see all  departmens on object 'Rank departmens'' for analisys ranks. But in object "Rank groups" he must see only groups on his departments1.

Managers of group have the same rule:

managers of group1 must see all groups on object "Rank groups", but he can only offices on his group in the object "Rank offices".

The reducing data must look like the following for user "chief of department1":

The object "Rank departments":

Department

Expression1

Expression2

Rank

Department1

275

1,2

2

Department2

350

1,8

1

Department3

100

0,9

3

The object "Rank groups":

Group

Expression1

Expression2

Rank

Group1_1 (Department1)

275

1,0

2

Group1_2 (Department1)

50

0,99

3

Group1_3 (Department1)

800

0,97

1

I must reduce data throught Section Access, not any Selected field and block field by Action, becouse data must be reduced.

Do you have any idea for resolving this problem?

1 Solution

Accepted Solutions
Not applicable

Re: Section Access- Reduce data for only some objects

I have solution for this issue.

I should select the Initial Selection Based on Section Access checkbox and than get current fieldname and lock it throught Document Properties->Triggers->OnOpen.

And than i should add set analisys in some tables  with ranks

View solution in original post

8 Replies
Not applicable

Re: Section Access- Reduce data for only some objects

If chief of department1 must see all  then:

USER

Department

Group

chief of department1

Department1

chief of department2

Department2

chief of department3

Department3

managers of group1_1

Department1

Group1_1

managers of group1_2

Department1

Group1_2

managers of group1_3

Department1

Group1_3

managers of group2_1

Department2

Group2_1

managers of group2_2

Department2

Group2_2

managers of group2_3

Department2

Group2_3

managers of group3_1

Department3

Group3_1

...

...

...

* - it is not "see all"

Not applicable

Re: Section Access- Reduce data for only some objects

In this case: * - all groups  in his department

Not applicable

Re: Section Access- Reduce data for only some objects

* не будет откатывать "показать всё"  при последующих загрузках, если ничего не задать для  учётки, то правильнее будет откатывать и не проходиться лишний раз.

И попробуй через колонку OMIT

Partner
Partner

Re: Section Access- Reduce data for only some objects

Konstantin,

Just keep in mind that * does not mean ALL. I explain.

Let's imagine that you have Groups A, B, C in Dept 1. You setup the section access as :

Chief            Dept_1 *

ManagerA      Dept_1      Group A

Manager B     Dept_1     Group B

Then using the *, the chief will only see the combination of the groups A and B found accross the section access, in the example above Chief will see Group A and B, not C ! Then keep the Group well empty to reach all Groups for the Chief.

HTH,

Michael

Partner
Partner

Re: Section Access- Reduce data for only some objects

The solution is through you model, you'll have to compute aggregates by Departments and fin a way that every department see the aggregates for the others but not the details.

Generally I do that by creating additonal column and a linktable wiht appropriate Key (Sorry I don't have any sample under the hand)

Maybe you could find sthg her : http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization

Michael.

Not applicable

Re: Section Access- Reduce data for only some objects

Michael, thank you, but this post (http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization) doesn't resolve my problem, it is perfect solutione for generation permissions, but i need something for pseudo- reducing data.

Not applicable

Re: Section Access- Reduce data for only some objects

I have solution for this issue.

I should select the Initial Selection Based on Section Access checkbox and than get current fieldname and lock it throught Document Properties->Triggers->OnOpen.

And than i should add set analisys in some tables  with ranks

View solution in original post

Partner
Partner

Re: Section Access- Reduce data for only some objects

Hi Ksenia,

Thanks for sharing that. Would you give me an example of the set analisys. I did what you said but a i don´t know how use it in a set analisys expresions..

thanks a lot

César B.