Chart Level Access by user

[jagan]

Hi,

Please find attached Qlikview document for implementing chart level access by user.  You can open the Qlikview file by using users A, B, C and D.  There is no Password for this file.

When you login as user A you can access both charts (CH01 and CH02).

When you login as user B you can access only one chart (CH01).

When you login as user C you can access only one chart (CH02).

When you login as user D you can access both charts (CH01 and CH02).

This is implemented by using Chart Properties -> Layout -> Show -> Conditional.

The charts and users are configured using ChartAccessMatrix table.  Refer below script for implementation.

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];

Regards,

Jagan.

[#2]

Hi,

Due to license problem,i cant open your qvw.could you please post a screenshot of the condition used in the chart?

Thanks

[jagan]

Hi Sudha,

I did like this

=Sum(CH01) > 0

Regards,

Jagan.

[#4]

Thank you jagan. Its working great..

[#5]

HELLO JAGAN, I WRITE MY SECTION ACCESS LIKE THIS.

SECTION Access;

LOAD * Inline [

ACCESS,USERID

ADMIN,MADHU

USER,KALYAN

USER,RAM

]

;

SECTION Application;

LOAD * Inline [

USERID,CH01,CHO2

MADHU,1,1

KALYAN,1,0

RAM,0,1

];

[#6]

WHAT IS THAT 1,1 AND 1,0 PLS EXPLAIN ME JAGAN AND WHICH PLACE I GIVE CONDITION AND HOW TO WRITE CONDITION.PLS TELL ME OUT JAGAN .

[jagan]

1 Means user have access to the chart, 0 means it won't show the chart.

[Anonymous]

Hi Jagan,

Thanks for sharing valuable information. Here I have one doubt, suppose if we have more than 100 charts in dashboard it is difficult to declare like below what you mentioned in your post.

ChartAccessMatrix:

LOAD * INLINE [

USERID, CH01, CH02

A,1,1

B,1,0

C,0,1

D,1,1];

Is there any alternative way to achieve this and also suppose if we want to assign to particular group to particular chart. What would be the solution.

Thanks.

[jagan]

Map users to groups and assign chart access to groups instead of users.

[#10]

Hi I went through all types of access level section as well as sheet and chart. I did not understand which one should i use. I want a particular user to see some apps and he should not be able top edit the script or view any of the tables.

[dharmarasu]

Hi Jagan,

This logic works only if the "Initial data reduction based os section access" option is checked.

In my report if I check that option, no one can access the report from access point including me.

However I am able to open in my local machine. What could be the issue?

Thanks!

Dharma