topic Re: QlikView Section Access - Efficiency Question in QlikView

QlikView Section Access - Efficiency Question

Wed, 27 May 2015 05:02:41 GMT

Hello,

I was wondering if anyone knows of the best way to work with a Section Access table concerning the following scenario: I have USER1 that has access to all of the Category numbers associated with F13. They also need to see Category 8300, however it is not part of F13. Instead of listing out each Category line by line for F13 in addition to 8300 in the Category column for USER1, is there an easier way I can do this in Section Access or the Table?

USER	AREA	CATEGORY
USER1	F13
USER1		8300

Thank you,

Etha

Re: QlikView Section Access - Efficiency Question

Wed, 01 Jul 2015 01:10:08 GMT

Hi Etha,

Are you getting data from AD Database? If yeas then you should write a query meet you requirement. You have an excel there you want to enter the data then you have to do it manually.

I had a requirement where I need to display all employee under a manager

USER EMPLOYEEID

Manger1 1

Manger1 2

Manger1 3

Employee1 1

Employee2 2

and this way I entered data.

Re: QlikView Section Access - Efficiency Question

vardhancse — Wed, 01 Jul 2015 03:26:51 GMT

Hi,

See to the below tread it might help you.

https://community.qlik.com/thread/153078

https://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization

Re: QlikView Section Access - Efficiency Question

qlikviewwizard — Wed, 01 Jul 2015 03:31:12 GMT

Hi komoroske ,

Your provided data is very confusing. Can you attach the sample qvw with sample data. So that it will help us better understanding the issue and to provide the efficient solution by our folks.

Re: QlikView Section Access - Efficiency Question

timanshu — Wed, 01 Jul 2015 09:39:24 GMT

You can keep area and category in a single row for user 1. It will work.User 1 will see reducted data by Area and category mentioned.