Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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