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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Section Access reduction based on 2 fields

Hi

I want to reduce the access depending the user, based on 2 files from 2 differet tables.

I have write the script below, but it doesn't work :

Section Access;

Load * inline

[ACCESS,               USERID,                         PASSWORD,      REDUCTION,      REDUCTION2

 

ADMIN,                               QVADMIN,    UPSIDER,           *,                         *

USER,                               TEST,                              TEST,                                   193,                         158

];

SECTION Application;

LOAD *,

COMMERCIAL_NUM as REDUCTION

FROM

\\As01\qlikview\loader\QV_RET_FAMILLES.QVD

(qvd);

  

LOAD *,

COMMERCIAL_NUM_FACT as REDUCTION2

FROM

\\As01\qlikview\loader\QV_RET_FACTURATIONS.QVD

(qvd)

Where FACTURATION_VALIDATION=1;

Can you Help me please

Regards

Laurent

Labels (1)
0 Replies