Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
santhosh_k_n
Creator II
Creator II

Object level section access

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

4 Replies
nirav_bhimani
Partner - Specialist
Partner - Specialist

HI,

Use QVUSER() function in the layout condition of object

E.g.

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

Regards,

Nirav Bhimani

santhosh_k_n
Creator II
Creator II
Author

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

jagan
Luminary Alumni
Luminary Alumni

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.

nirav_bhimani
Partner - Specialist
Partner - Specialist

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