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

Section access with Multiple fields

Hi All,

I am facing a problem in data security using section acccess. I am unable to filter the data based on multiple fields.

As a user I need to see full projects of one company and some projects of other company where I am the user.

My Data is :

COMPANYIDPROJIDPM
A1001USER1
A1002USER1
A1003USER2
B1004USER2
B1005USER2
B1006USER3
C1007USER3
C2008USER3
C1009USER4


My Access Matrix table is :

AccessUserIDCompanyIDProjID
ADMINUSER**
USERUSER1A1001
USERUSER1A1002
USERUSER2A*
USERUSER2B1004
USERUSER2B1005
USERUSER3B*
USERUSER3C1007
USERUSER3C1008
USERUSER4C1009

and my output for USER2 shoulsd be :

Company IDProj ID PM
A1001USER1
A1002USER1
A1003USER2
B1004USER2
B1005USER2

Thanks in advance.

Attached excel file for your reference.

Regards,

Veman Reddy

1 Reply
Not applicable
Author

Hi ,

Please Find The Attached Application and Please Use the Attached Excel