topic Row Level Security in Qlikview in QlikView

Row Level Security in Qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone

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

Thank You

Re: Row Level Security in Qlikview

rubenmarin — Wed, 31 May 2017 21:31:57 GMT

Hi prachi, row and column security can be applied using section access, in qlik help there is an example using row level security (using the REDUCTION field) and column security (using OMIT):

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/Security/dynamic-data-reduction.htm

You have also tons of documents in the community:

Section Access

This one a few simple example about row security:

QlikView Section Access Examples

Re: Row Level Security in Qlikview

Anonymous — Thu, 01 Jun 2017 03:32:12 GMT

This can be implement by using Section Access.

Row Level

Column Level

Chart Level

Document Level

Object Level

Have a look: Good Explanation with Example

Various levels of security implementation using Section Access

Hope it helps!!

Re: Row Level Security in Qlikview

Anonymous — Thu, 01 Jun 2017 10:59:31 GMT

i get an error while i am running below script 'FILE NOT FOUND <ACCESS>'

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

USER, PRACHI, 123

ADMIN, BHAGWAT, 456

];

Section Application;

row_level:

LOAD ACCESS,

CUST_ID,

CUST_NAME,

PROD_ID

FROM

[..\..\Qlikview\Source\Data.xlsx]

(ooxml, embedded labels, table is tbl_cust);

Re: Row Level Security in Qlikview

rubenmarin — Thu, 01 Jun 2017 11:24:50 GMT

Hi, those 3 fields are for document security only, if you want to add row level you need another field that does the reduction, ie:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, AREA

USER1, PRACHI, 123, 1

USER2, PRACHI2, 123, 2

ADMIN, BHAGWAT, 456, *

];

Section Application;

row_level:

LOAD AREA, //This should be a real field with values related to users

CUST_ID,

CUST_NAME,

PROD_ID

FROM

[..\..\Qlikview\Source\Data.xlsx]

(ooxml, embedded labels, table is tbl_cust);

Re: Row Level Security in Qlikview

Anonymous — Thu, 01 Jun 2017 18:47:51 GMT

STILL I GET AN ERROR...

"file not found"

Re: Row Level Security in Qlikview

Anonymous — Thu, 01 Jun 2017 19:46:40 GMT

What error message are you getting? Can you post sample image

Re: Row Level Security in Qlikview

devarasu07 — Thu, 01 Jun 2017 20:18:25 GMT

Hi,

Here is simple analysis - row level security option through section access

1) keep below script into back end

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, AFRICA

USER, USER2, U2, AMERICA

USER, USER3, U3, ASIA

USER, USER4, U4, EUROPE

USER, USER5, U4, AMERICA

USER, USER5, U5, *

];

Section Application;

SALES:

LOAD * INLINE [

REGION, PROFIT

AFRICA, 1000

AMERICA, 2000

ASIA, 3000

EUROPE, 4000

OCEANIA, 5000

];

2) STEP2,

3) IF ANY ISSUE IN OUR Setup, by grading below order admin security will help to open doc.

Re: Row Level Security in Qlikview

rubenmarin — Thu, 01 Jun 2017 22:21:01 GMT

If it says "file not found" seems than the path to the xlsx is different:

[..\..\Qlikview\Source\Data.xlsx]

This one should point where your xlsx is

Re: Row Level Security in Qlikview

Peter_Cammaert — Thu, 01 Jun 2017 22:23:45 GMT

Check your Excel data source "Data.xlsx". Is there a column present with the name ACCESS in all capitals on worksheet tbl_cust?

Re: Row Level Security in Qlikview

Anonymous — Sat, 03 Jun 2017 19:13:07 GMT

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 ..

Re: Row Level Security in Qlikview

Anonymous — Sun, 04 Jun 2017 05:01:44 GMT

Have a look: Re: Disable Hidden Script in menu

Re: Row Level Security in Qlikview

Anonymous — Sun, 04 Jun 2017 06:08:51 GMT

there is no solution..

Re: Row Level Security in Qlikview

rubenmarin — Sun, 04 Jun 2017 21:55:20 GMT

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

Re: Row Level Security in Qlikview

Anonymous — Mon, 05 Jun 2017 06:10:08 GMT

If you login with Admin credentials it will be enabled.

Re: Row Level Security in Qlikview

Anonymous — Wed, 07 Jun 2017 10:27:06 GMT

i tried this all but still authentication is not working.

Re: Row Level Security in Qlikview

Anonymous — Wed, 07 Jun 2017 12:17:44 GMT

You are not able to open the file?

Re: Row Level Security in Qlikview

Anonymous — Wed, 07 Jun 2017 18:02:06 GMT

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.......

Re: Row Level Security in Qlikview

Anonymous — Wed, 07 Jun 2017 18:33:00 GMT

Did you followed this?

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

Re: Row Level Security in Qlikview

Anonymous — Wed, 07 Jun 2017 19:07:58 GMT

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