Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Section Access: Restrict values in one table while keeping values in another

Hi,

I have two tables; Table1 has fields A and B, Table2 has fields A and D.

I've set up section access with reduction on field B:

SECTION ACCESS;

LOAD * INLINE [

     ACCESS, NTNAME, B

     ADMIN, domain\user, *

     USER, domain\user, value

];

SECTION APPLICATION;

...

The problem I'm struggling to solve is that everything from Table2 is being excluded, which is understandable as field B doesn't exist in that table. Do any of you know of a way that I can restrict the values in Table1, whilst excluding NO values in Table2?

Thanks