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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Krishna_Chaitanya
Partner - Contributor
Partner - Contributor

How can I dynamically implement section access based on region and country fields

How can I dynamically implement section access across specifically using two linked  fields like region and country to avoid manually listing every country entry? 

Thanks.

1 Reply
marcus_sommer
MVP
MVP

The section access information mustn't be mandatory applied manually else any kind of script could be used to create an appropriate table. In your case you might be consider a cartesian join with a following filtering, maybe something like:

t1: load Country & '|' & Region as Key from Countries;
     join(t1) load User from Users;

t2: load * resident t1 where ....;