topic Re: Section Access on two fields in QlikView https://community.qlik.com/t5/QlikView/Section-Access-on-two-fields/m-p/714659#M257187 <HTML><HEAD></HEAD><BODY><P>you can also expand the values in city field and remove the country</P><P></P><P>USER&nbsp;&nbsp;&nbsp;&nbsp; CITY</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MUMBAI</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELHI</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANGALORE</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ......</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">BEIJING</SPAN></P></BODY></HTML> Mon, 13 Oct 2014 20:07:46 GMT maxgro 2014-10-13T20:07:46Z Section Access on two fields https://community.qlik.com/t5/QlikView/Section-Access-on-two-fields/m-p/714657#M257185 <HTML><HEAD></HEAD><BODY><P>I am implementing section access on two fields. I have one scenario for an example. i am doing section access on Field A&nbsp; which is Country and Field B which is City</P><P></P><P>USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COUNTRY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CITY</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INDIA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<BR />A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHINA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BEIJING</P><P></P><P>I have to give access to user A on all cities from india and only beijing city from China, How to write section access piece for this so that user A gets correct privileges?</P></BODY></HTML> Mon, 13 Oct 2014 13:51:21 GMT https://community.qlik.com/t5/QlikView/Section-Access-on-two-fields/m-p/714657#M257185 rsdhavle 2014-10-13T13:51:21Z Re: Section Access on two fields https://community.qlik.com/t5/QlikView/Section-Access-on-two-fields/m-p/714658#M257186 <HTML><HEAD></HEAD><BODY><P>I think this could be helpful: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields">http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields</A></P><P></P><P>- Marcus</P></BODY></HTML> Mon, 13 Oct 2014 15:03:12 GMT https://community.qlik.com/t5/QlikView/Section-Access-on-two-fields/m-p/714658#M257186 marcus_sommer 2014-10-13T15:03:12Z Re: Section Access on two fields https://community.qlik.com/t5/QlikView/Section-Access-on-two-fields/m-p/714659#M257187 <HTML><HEAD></HEAD><BODY><P>you can also expand the values in city field and remove the country</P><P></P><P>USER&nbsp;&nbsp;&nbsp;&nbsp; CITY</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MUMBAI</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELHI</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANGALORE</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ......</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">BEIJING</SPAN></P></BODY></HTML> Mon, 13 Oct 2014 20:07:46 GMT https://community.qlik.com/t5/QlikView/Section-Access-on-two-fields/m-p/714659#M257187 maxgro 2014-10-13T20:07:46Z