topic Re: section access in QlikView

section access

Thu, 18 Sep 2014 14:43:15 GMT

Hi all,

I am trying to implement section access in my qvw. but data reduction is not happening (i mean when i enter user1 only sho1 and sho9 has to show) but it is not happening . i have checked the initial reduction in document properties. what would be the problem??

Section

Access

;
LOAD

* INLINE

[
ACCESS, USERID,PASSWORD, GROUP
ADMIN,ADMIN,123,ALL
USER,USER1,123,GROUP2
USER,USER2,123,GROUP2
USER,USER3,123,GROUP2
ADMIN,USER4,123, ALL
]

;
Section

Application

;

Permisions:
LOAD

* INLINE

[
GROUP,SH01,SH05,SH08,SH09
ALL,1,1,1,1
GROUP2,1,0,0,1
]

;

Re: section access

Anonymous — Thu, 18 Sep 2014 14:55:42 GMT

to my knowledge there is no way that tabs are automatically hidden

I use conditional show of Tabs

In your case the condition would be SH01=1 etc.

Re: section access

Thu, 18 Sep 2014 20:09:02 GMT

If you are referring to columns sh01 and sh09 in the 'permission' Table and not the actual sheets with ID SH01/09, then here is the explanation (else just ignore it):

Section access will reduce (restrict) access to 'rows' that a user have access to, Group2 in this case.

So USER1 does not see rows that have Group='ALL', but only those rows that have Group=Group2.

Columns/Sheets have to be conditionally hidden as Rudolf rightly mentioned.

P.S. In the document properties --> opening tab, its good idea to check mark 'Strict Exclusion' option as well along with initial reduction.

Regards,

Kalpesh

Re: section access

Anonymous — Thu, 18 Sep 2014 20:46:57 GMT

it's easily, look to the qvw attached. Use your credentials to open the application.

Re: section access

jagan — Fri, 19 Sep 2014 03:55:26 GMT

Hi,

Check this link

Sheet level access

Sheet Level Access

Regards,

Jagan.