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.

[qlikuser222]

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

[jagan]

Hi,

Just replace USERID with NTNAME that's it.

Regards,

Jagan.

[#4]

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

[jagan]

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

[aapurva09]

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.

[jagan]

Hi Apurva,

Are you using the same account in Accesspoint?

Regards,

jagan.

[Anonymous]

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

[manojkumargowda]

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