0 Replies Latest reply: Apr 22, 2013 11:19 AM by Ankri Laurent RSS

    Section Access reduction based on 2 fields

    Ankri Laurent

      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