topic Section access case in QlikView

Section access case

Wed, 19 Jun 2013 10:38:09 GMT

Hello,

I have a case with section access.

I have two users using the same document. There are two product groups - the one is responsible for the first, the other for the second.

They both need to see the sales of both groups however they can only see the profit of their own group.

Any idea how to do this?

Re: Section access case

Wed, 19 Jun 2013 11:13:16 GMT

Hi ,
Yes u can try This

First u need to create a security table

Please find below tables ;

example

SecurityTable:
Load

SalesGroup Division
ADMIN A

ADMIN                         B
ADMIN                         C
ADMIN                         D
ProductGroup1             A

ProductGroup1             B
ProductGroup2             C
ProductGroup2             D

join

Load
ACCESS USERID   PASSWORD User Name SalesGroup
ADMIN   qvadmin    123                  *                      ADMIN
USER   *                 *                User1       ProductGroup1
USER   *                 *                User2       ProductGroup2

Hope above securitytable will work.

Regards-Bika

Re: Section access case

Wed, 19 Jun 2013 12:49:15 GMT

Hi,

i am not sure how that prevents user1 to see the profit of sales from productgroup2?

If i have table like the one below and the user1 access it, he cant see only the red labelled data. And vica versa for user2..

User	Productgroup	sales	profit
User1	Productgroup1	sales1	profit1
User2	Productgroup2	sales2	profit2

It is neither row restriction nor column restriction... And i dont know any combined solution..