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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

Section Access

Hi,

here is my Section access script:

star is * ;

Section Access;

SATABLE:

LOAD upper(ACCESS) as ACCESS,

     upper(NTNAME) as NTNAME,

     upper(SAUSER) as SAUSER

From xyz;

Section Application;

Document_Security:

LOAD

          upper(SAUSER) as SAUSER,

          FIELDACCESS.PROGRAM,  (I want to filter the SAUSER for multiple program and not just one)

          TABACCESS.PCA,

          TABACCESS.PDD

From ABC;

Instead of creating multiple rows of record for a particular SAUSER to filter on Programs ( eg: Program Names: SAP, ADP, USC etc) how can I accomodate all the constraints/filter for program in one row of record for that SAUSER?

Thanks,

H

0 Replies