Qlik Community

QlikView Documents

Documents for QlikView related information.

Chart Level Security

MVP & Luminary
MVP & Luminary

Chart Level Security

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.

Attachments
Comments
MVP
MVP

Thanks for sharing.. It's asking for password.

0 Likes
MVP & Luminary
MVP & Luminary

No Need of password just press enter key.

0 Likes
abhaysingh
Valued Contributor II

Hi Jagan,

Thanks for revert...

But this is Chart level security that is i am understanding.. but i want in first chart the data should reduce by North and in Second chart the data should reduce by North and South.

Regards

Abhay

0 Likes
mayankraoka
Valued Contributor

That you can apply in the chart itself so the person having access to particular chart will get that data only

0 Likes
ecolomer
Honored Contributor II

Thank's for sharing.

0 Likes
Not applicable

Thanks it is helpful

0 Likes
Partner
Partner

Thanks for sharing. It will be usefull

0 Likes
Partner
Partner

Hi Jagan,

Thanks for sharing.. It's asking for password.I enetered Enter key. but its saying Failed to open document.


Please advise.


Thanks

Kesav

0 Likes
MVP & Luminary
MVP & Luminary

Not sure, it is working for me just given user ID as A or B or C or D.

Regards,

Jagan.

Not applicable

Hi,

Thanks for your post,

I do your comment , but when i open my document and write userId,

I see all charts.

What can i do ?

Regards

Hamide

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-04-21 01:35 AM
Updated by: