Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

laurent_ankri
New Contributor

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

Tags (2)
Community Browser