Qlik Community

QlikView Documents

Documents for QlikView related information.

Chart Level Access by user

MVP
MVP

Chart Level Access by user

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.

Labels (3)
Attachments
Comments
Not applicable

Hi,

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

Thanks

MVP
MVP

Hi Sudha,

I did like this

=Sum(CH01) > 0

Regards,

Jagan.

Not applicable

Thank you jagan. Its working great..

Not applicable

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

];

Not applicable

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 .

MVP
MVP

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

kumarreddy257
Contributor

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.

MVP
MVP

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

Not applicable

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
Contributor

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

Version history
Revision #:
1 of 1
Last update:
‎04-15-2014 06:40 AM
Updated by: