Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies