Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

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
Arjunarao
Honored Contributor II

Hi MayilVahanan

Good document. Thank you for sharing.

daniel_kusiak
Contributor II

Hi Mayil Vahanan Ramasamy

Thanks for sharing.

manojkulkarni
Valued Contributor II

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

qlikviewnovice
Valued Contributor II

Good One!! Thank You for Sharing

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