topic Re: Object level section access in QlikView

Object level section access

santhosh_k_n — Tue, 25 Mar 2014 05:04:31 GMT

Hi All,

I need to apply section access such a way, depending on the user log in the number of objects visible to the user must vary.

Let say, I am having 10 charts

if user1 login to the report all 10 charts to be visible

if user2 log in only first 5 reports to be visible

if user3 then last 5 and

if user4 then chart 3,4,7,9,10 should be visible.

Please help me

Re: Object level section access

nirav_bhimani — Tue, 25 Mar 2014 05:12:50 GMT

HI,

Use QVUSER() function in the layout condition of object

E.g.

If(QVUSER()='XYZ',1,0)

Regards,

Nirav Bhimani

Re: Object level section access

santhosh_k_n — Tue, 25 Mar 2014 05:17:35 GMT

Thanks Nirav,

1. This works fine for limited user and limited charts,if users are more are around 20 to 30 then its bit difficult

2. If my section access is NT based will it work

Re: Object level section access

jagan — Tue, 25 Mar 2014 05:22:26 GMT

Hi Santosh,

Please find attached file for solution

Script used in the file.

Section Access;

LOAD * INLINE [

ACCESS, USERID

Admin, A

User, B

User, C

USer, D

];

Section Application;

ChartAccessMatrix:

LOAD * INLINE [

USERID, CH01, CH02

A,1,1

B,1,0

C,0,1

D,1,1];

When A user access the Dashboard he can see both CH01 and CH02.

When D user access the Dashboard he can see both CH01 and CH02.

When B user access the Dashboard he can see only CH01.

When c user access the Dashboard he can see only CH02.

Hope this helps you.

Regards,

jagan.

Re: Object level section access

nirav_bhimani — Tue, 25 Mar 2014 05:25:04 GMT

Hi,

If you want to show particular chart to many user and hide to few user then write this condition is reverse way

It will work with NT name as well.

If(Wildmatch(QVUSER(),'XYZ','abc'),0,1)

Regards,

Nirav Bhimani