topic Section Access based on single field with multiple value in QlikView https://community.qlik.com/t5/QlikView/Section-Access-based-on-single-field-with-multiple-value/m-p/1236125#M850357 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please help me to get the solution for the below scenario.</P><P>For Eg:</P><P>Table1:</P><P>Country, Group</P><P>UK,ABC</P><P>US,XYZ</P><P>HK,PQR</P><P>US,ABC</P><P>HK,ABC</P><P>India, XYZ</P><P></P><P>Table2:</P><P>Country, Sales,Item</P><P>UK,200,A</P><P>US,300,B</P><P>India,400,C</P><P>HK,500,D</P><P></P><P>Result:</P><P>Apply section Access for a user who belong to group ABC&nbsp; but his country is US, can able to see the data for UK,US,HKand India at high level but he can able to drill down for US.</P><P> I tried to create a excel which is containing multiple rows based on Group and Country but i want all those information in one row&nbsp; and apply section access on that</P><P>For eg. Expected Result:</P><P>User , Group, Country1, Country2,country3,country4 and so on</P><P>A,ABC,UK,US,HK</P><P></P><P>What i have:</P><P>User,group,country</P><P>A ABC Uk</P><P>A ABC US .. and so on</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT nisha_rai 2020-11-25T16:16:04Z Section Access based on single field with multiple value https://community.qlik.com/t5/QlikView/Section-Access-based-on-single-field-with-multiple-value/m-p/1236125#M850357 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please help me to get the solution for the below scenario.</P><P>For Eg:</P><P>Table1:</P><P>Country, Group</P><P>UK,ABC</P><P>US,XYZ</P><P>HK,PQR</P><P>US,ABC</P><P>HK,ABC</P><P>India, XYZ</P><P></P><P>Table2:</P><P>Country, Sales,Item</P><P>UK,200,A</P><P>US,300,B</P><P>India,400,C</P><P>HK,500,D</P><P></P><P>Result:</P><P>Apply section Access for a user who belong to group ABC&nbsp; but his country is US, can able to see the data for UK,US,HKand India at high level but he can able to drill down for US.</P><P> I tried to create a excel which is containing multiple rows based on Group and Country but i want all those information in one row&nbsp; and apply section access on that</P><P>For eg. Expected Result:</P><P>User , Group, Country1, Country2,country3,country4 and so on</P><P>A,ABC,UK,US,HK</P><P></P><P>What i have:</P><P>User,group,country</P><P>A ABC Uk</P><P>A ABC US .. and so on</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Section-Access-based-on-single-field-with-multiple-value/m-p/1236125#M850357 nisha_rai 2020-11-25T16:16:04Z