Section Access Data Reduction problem

Wed, 25 Nov 2020 16:16:04 GMT

Hi, Im trying to reduce data based on SalesReps,

In this case im trying to reduce data based on salesreps, i have SalesRep named "TEST" in excel file.

So every time user "TEST" is opening the qvw, he should see his Sales, not everybodies. First i create the SA, then i link the User to the user in the application.

Is there something im doing wrong ?

See below script:

Excelfile:

USERID	PASSWORD	ACCESS
TEST	123	USER
ADMIN	ADMIN	ADMIN

SECTION Access;

SA_TEST:

LOAD

upper(USERID) as USERID,

upper(PASSWORD) as PASSWORD,

upper(ACCESS) as ACCESS

FROM

(ooxml, embedded labels, table is Sheet2);

SECTION Application;

SA_LINK:

LOAD

USERID as Salesman

resident SA_TEST;

topic Section Access Data Reduction problem in QlikView

Section Access Data Reduction problem