Qlik Community

QlikView Documents

Documents for QlikView related information.

Chart Level Security

MVP
MVP

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

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

MVP
MVP

No Need of password just press enter key.

abhaysingh
Contributor III

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

mayankraoka
Valued Contributor

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

ecolomer
Honored Contributor II

Thank's for sharing.

Not applicable

Thanks it is helpful

manojkulkarni
Valued Contributor II

Thanks for sharing. It will be usefull

psankepalli
Contributor III

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

MVP
MVP

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

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