Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
prachi91
Creator III
Creator III

Row Level Security in Qlikview

Hello everyone

how to implement row level and column level Security in qlikview with example?

Thank You

27 Replies
prachi91
Creator III
Creator III
Author

i solved that error...

but there is one issue while i creating hidden script and after reload when i restart qlikview and open the file that time  hidden script tab and options are invisible  ..hidden.png

qlikviewnovice
Specialist II
Specialist II

prachi91
Creator III
Creator III
Author

there is no solution..

rubenmarin

If you open QV as admin (BHAGWAT) the option should be avaible.

qlikviewnovice
Specialist II
Specialist II

If you login with Admin credentials it will be enabled.

prachi91
Creator III
Creator III
Author

i tried this all but still authentication is not working.

qlikviewnovice
Specialist II
Specialist II

You are not able to open the file?

prachi91
Creator III
Creator III
Author

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, Zone

    ADMIN, ADMIN, ADMIN, *

    ADMIN, SCOTT, TIGER, North

    USER, USER1, 123, South

    USER, USER2, 123, West

];

Section Application;

LOAD * INLINE [

    Zone, Sales Amount

    North, 8596321

    South, 745896

    West, 3364144

    East, 12897966

];

as per above script SCOTT have authority to access only North data and USER1 can access only South data but when i open that file as a SCOTT or USER1 it shows all data like NORTH,SOUTH,WEST & EAST.

i tried all possibilities but still.......

qlikviewnovice
Specialist II
Specialist II

Did you followed this?

You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option


qlikviewnovice
Specialist II
Specialist II

Try now it will work

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, REDUCTION

    ADMIN, ADMIN, ADMIN, *

    USER, USER1, 123, 1

    USER, USER2, 123, 2

];

Section Application;

star is *;

Zones:

LOAD * INLINE [

REDUCTION, Zone

1, North

2, South

];

Sales:

LOAD * INLINE [

   Zone, Sales

   North, 100

   North, 200

   North, 4646

   North, 755

   North, 422

   North, 42

   South, 2

   South, 453

   South, 54

   South, 45

];

You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option