Hi Andy, We can do this with help of section Access.
Firstly, you need to create the Security QVD with help of excel file.
LOAD UPPER(USERNAME) AS NTNAME ,
'USER' AS ACCESS
LOAD * FROM EXCEL_FILE
Where KEY_WORD = 'Active' ; (This place you need to provide the logic)
LOAD * INLINE [
NTNAME , ACCESS
QVSERVICEACCOUNT , ADMIN
STORE Security into Security.qvd (qvd) ;
Use this Security QVD in the section Table in the main application.
Section Access ;
LOAD NTNAME , ACCESS FROM Security.qvd (qvd) where 1=1 ;
Section Application ;
Please check the Initial Data Reduction Based on Section Access option in Document Properties --> Opening Tab