Qlik Community

QlikView Documents

Documents for QlikView related information.

Level Wise Security Access

Level Wise Security Access

Hi All,

Please find the level wise Security Access sample document.

Hope it helps for someone.

SECTION Access;

LOAD * Inline

[

USERID, PASSWORD, ACCESS, %KEY

A, A, ADMIN, *

B, B, USER, ANN|BI|QV

C, C, USER, ANN|*|*

D, D, USER, BNN|AT|*

E, E, USER, BNN|BT|SSIS

];

SECTION Application;

Table1:

LOAD *,L1&'|'&L2&'|'&L3 AS KEY INLINE [

    L1, L2, L3

    ANN, BI, QV

    ANN, BI, TABLEAU

    BNN, AT, MICRO

    BNN, AT, INFORMATICA

    BNN, BT, SSIS

];

Table2:

LOAD Distinct KEY, L1 & '|*|*' AS %KEY Resident Table1;

Concatenate(Table2)

LOAD Distinct KEY, L1 & '|' & L2 & '|*' AS %KEY Resident Table1;

Concatenate(Table2)

LOAD Distinct KEY, L1 & '|' & L2 & '|' & L3 AS %KEY Resident Table1;

User A  can see all the data.

User B can see the ANN | BI| QV data alone.

User C can see the ANN details and so on.

Labels (1)
Attachments
Comments
qlikviewwizard
Honored Contributor II

Hi MayilVahanan

Good document. Thank you for sharing.

daniel_kusiak
Contributor II

Hi Mayil Vahanan Ramasamy

Thanks for sharing.

Partner
Partner

Thanks for Document. Do you have any document having security level implemented at tab level.

0 Likes
qlikviewnovice
Valued Contributor II

Good One!! Thank You for Sharing

Version history
Revision #:
1 of 1
Last update:
‎2015-07-22 08:55 AM
Updated by: