topic Re: Row Level Access QlikView in QlikView

Row Level Access QlikView

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

Hi!

I´ve a problem with my QlikView report. I´m starting to apply a row level security.

I have a simple COUNTRY list and I want to filter the information that each User can see. Also I want to load all the users data and access from an external Excel file called "rowlevel". I have created that with the following table:

ACCESS	USERID	COUNTRY
ADMIN	A	*
USER	B	Brazil
USER	C	Finland
USER	D	Greece
USER	E	Argentina

My idea is that User A can see all countries and the other users can see only a specific country.

I load this script but it does not work

LOAD * INLINE [

COUNTRY

Argentina

Brazil

Chile

Spain

Greece

Ireland

Bolivia

USA

Australia

New Zeland

Canada

South Africa

Morocco

];

Section Access;

LOAD upper([USERID]) as [USERID],

ACCESS as ACCESS,

COUNTRY

FROM

rowlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

SheetAccessMatrix:

LOAD upper([USERID]) as [USERID],

ACCESS as ACCESS

FROM

rowlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

Could you help me?

Thanks!!

Message was edited by: Raul Alberto Dip

Re: Row Level Access QlikView

Anonymous — Wed, 25 Apr 2018 15:17:56 GMT

I´ve changed the script as this:

LOAD * INLINE [

COUNTRY

Argentina

Brazil

Chile

Spain

Greece

Ireland

Bolivia

USA

Australia

New Zeland

Canada

South Africa

Morocco

];

Section Access;

LOAD upper([USERID]) as [USERID],

ACCESS as ACCESS

FROM

rowlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

SheetAccessMatrix:

LOAD upper([USERID]) as [USERID],

ACCESS as ACCESS,

COUNTRY

FROM

rowlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

The problem is that the "all countries" USER A doesn´t work! It add a "*" country instead of allow to see all countries!

Re: Row Level Access QlikView

olivierrobin — Wed, 25 Apr 2018 15:19:16 GMT

hello

what do you mean when you say : it doesn't work , what happens ?

did you enable reduction and/or exclusion in document properties ?

Re: Row Level Access QlikView

olivierrobin — Wed, 25 Apr 2018 15:20:09 GMT

you mav have to add

star is *;

Re: Row Level Access QlikView

Anonymous — Wed, 25 Apr 2018 15:23:26 GMT

Sorry I ve upload an old version of "rowlevel" file on the post, in which USER A has a "Argentina" in the COUNTRY Column. The file that i´m trying to use actually has a * on COUNTRY column for that USER A. I will update the post.

Re: Row Level Access QlikView

Anonymous — Wed, 25 Apr 2018 15:32:11 GMT

How could I enable a Reduction/Exclusion option?

with this script, when i log in with the USER B I can only see "Brazil", that is right. But when I try to log in with User A I see a "*" country instead of all countries.

LOAD * INLINE [

COUNTRY

Argentina

Brazil

Chile

Spain

Greece

Ireland

Bolivia

USA

Australia

New Zeland

Canada

South Africa

Morocco

];

Section Access;

LOAD upper([USERID]) as [USERID],

ACCESS as ACCESS

FROM

rowlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

SheetAccessMatrix:

LOAD upper([USERID]) as [USERID],

ACCESS as ACCESS,

COUNTRY

FROM

rowlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Row Level Access QlikView

olivierrobin — Wed, 25 Apr 2018 15:34:20 GMT

so you have to use

star is *;

Re: Row Level Access QlikView

olivierrobin — Wed, 25 Apr 2018 15:38:57 GMT

before loading SheetAccessMatrix

Re: Row Level Access QlikView

Anonymous — Wed, 25 Apr 2018 18:04:20 GMT

Yes!!! That works!!!

Thanks!!