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: 
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