topic Re: Sheet level security in QlikView

Sheet level security

brijesh1991 — Wed, 01 Jul 2015 04:17:05 GMT

Hi All,

I am implementing sheet level security+reduction of few sheets. I have total four sheets. In Two sheets, I do not want to reduce data, but in rest two sheets I want to reduce data based on a field present in my datamodel.

Example:

In attached snapshot, for NTNAME: 548578. Sheet: SH31, SH04, SH05 should be visible and again SH31 and SH04 should not be reduced at all; while SH05 sheet should be reduced for CHANNEL=DF (Mentioned in section access; this field in present in datamodel).

For NTNAME:985784; Sheet: SH31, SH04, SH05, SH06 should be visible and again SH31 and SH04 should not be reduced at all; while SH05 and SH06 sheets should be reduced for CHANNEL=AB (Mentioned in section access; this field in present in datamodel).

Your help would be appreciated.

Thanks,

BRIJESH

Re: Sheet level security

marcus_sommer — Wed, 01 Jul 2015 11:20:20 GMT

Maybe this is helpful for you:

Sheets Security with Section Access

Section Access - Hide Sheet Level

Sheets Security with Section Access File

- Marcus

Re: Sheet level security

avinashelite — Wed, 01 Jul 2015 11:32:07 GMT

Hi Brijesh,

As per my knowledge in Qlikview the Data reduction cannot be achieved like that , the data will reduce across all the sheets. Based on the sheets we cannot reduce the data, if you don't have data dependence than create two separate data mart like for 2 sheets one data mart and for other another data mart

Re: Sheet level security

Anonymous — Thu, 25 Feb 2016 09:54:44 GMT

The example of sheet level security

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,PROFILE

admin, college, college,COLLEGE

user, physics, physics,PHYSICS

user, chemistry, chemistry,CHEMISTRY

user, maths, maths,MATHS

];

Section Application;

Profile:

LOAD * INLINE [

PROFILE, SH01, SH02, SH03, SH04

PHYSICS, 1, 1, 0, 0

CHEMISTRY, 1, 0, 0, 1

MATHS, 1, 0, 1, 0

COLLEGE, 1, 1, 1, 1