Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access Data Reduction problem

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:

USERIDPASSWORDACCESS
TEST123USER
ADMINADMINADMIN

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;

0 Replies