Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data restriction

Hi All,

Please guide me how to implement security

Example

UserLis:

ACCESS , NTNAME, REGION, COUNTRY

ADMIN     , ABCDE    , *, *

USER1,  U1, ASIA,

USER1, U1, EUROPE,  GERMANY

FACTTABLE:

REGION, COUNTRY

ASIA, INIDA

ASIA, SINGAPORE
ASIA, JAPAN

EUROPE, GERMANY

EUROPE, SWEDEN

EUROPE, GREEK

when user1 logs in he has to see country which are all in ASIA region and germany country

output should be

ACCESS, NTNAME, REGION, COUNTRY

USER1, U1, ASIA, INDIA

USER1,U1, ASIA, SINGAPORE

USER1, U1, ASIA, JAPAN

USER1, U1, EUROPE, GERMANY

Thanks in advance

0 Replies