article Chart Level Access by user in Member Articles

Chart Level Access by user

jagan — Fri, 07 Oct 2022 13:26:27 GMT

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.

Re: Chart Level Access by user

Tue, 10 Feb 2015 04:59:33 GMT

Hi,

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

Thanks

Re: Chart Level Access by user

jagan — Tue, 10 Feb 2015 05:16:07 GMT

Hi Sudha,

I did like this

=Sum(CH01) > 0

Regards,

Jagan.

Re: Chart Level Access by user

Tue, 10 Feb 2015 05:55:20 GMT

Thank you jagan. Its working great..

Re: Chart Level Access by user

Tue, 02 Jun 2015 14:31:24 GMT

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

];

Re: Chart Level Access by user

Tue, 02 Jun 2015 14:32:54 GMT

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 .

Re: Chart Level Access by user

jagan — Wed, 03 Jun 2015 04:18:51 GMT

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

Re: Chart Level Access by user

Anonymous — Tue, 15 Mar 2016 09:11:08 GMT

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.

Re: Chart Level Access by user

jagan — Wed, 16 Mar 2016 01:38:28 GMT

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

Re: Chart Level Access by user

Thu, 07 Apr 2016 14:55:26 GMT

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.

Re: Chart Level Access by user

dharmarasu — Thu, 28 Apr 2016 12:31:13 GMT

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

Re: Chart Level Access by user

qlikuser222 — Fri, 30 Sep 2016 14:34:03 GMT

HI Jagan,

How does it work in the server if we use NTNAME instead of USERID?

I tried it bby deploying dashboard in the server, but it takes Servers NTNAME and object level security is not achievable there.

Can you please help me?

Thanks

Re: Chart Level Access by user

jagan — Mon, 03 Oct 2016 03:31:04 GMT

Hi,

Just replace USERID with NTNAME that's it.

Regards,

Jagan.

Re: Chart Level Access by user

Thu, 27 Oct 2016 19:40:24 GMT

Hello Jagan,

I downloaded the qvw file and tried to open with A. It worked perfectly but than I tried to open it with other users and it failed to open. I am not sure why that happened.

Also, I tried the similar approach with me qvw on the server with NTNAME. And it is failing to open for all of my users. Am I missing something?

Any help is greatly appreciated.

Thank you

Parth

Re: Chart Level Access by user

jagan — Mon, 31 Oct 2016 06:00:10 GMT

If you are using windows account then you have to user NTNAME otherwise you need to use USERID.

Re: Chart Level Access by user

aapurva09 — Wed, 02 Nov 2016 06:22:07 GMT

Hi Jagan,

I replaced USERID with NTNAME and checked Strict Exclusion in Document Settings, as the sane you did in your application. I am using windows authentication.

But in access point it says you don't have access to the document even for me, however I am able to open it from Qlikview desktop but not from Access Point.

Any idea why this is happening? Please help.

Re: Chart Level Access by user

jagan — Thu, 10 Nov 2016 08:56:48 GMT

Hi Apurva,

Are you using the same account in Accesspoint?

Regards,

jagan.

Re: Chart Level Access by user

Anonymous — Mon, 09 Oct 2017 06:56:30 GMT

Hi Parth,

The values in the USER field in the qvw, are in Camel case. If you make them Upper Case, the qvw will work properly.

Regards,

Subrat

Re: Chart Level Access by user

manojkumargowda — Wed, 18 Apr 2018 06:12:23 GMT

Hi Guys,

As many people pointed out here, this is not working in SERVER with NTNAME. It is throwing error "Failed to open document, You don't have access to this document.".

Did anybody found out the answer for this? Please share if you know about this.

Regards,

Manoj