https://community.qlik.com/t5/App-Development/Section-Access-Combining-Field-Reduction-and-OMIT/m-p/1527593#M40475 <P>Hi All</P><P>I have below&nbsp;Requirement in section access.</P><P><STRONG><SPAN>Requirement&nbsp;</SPAN></STRONG></P><P><SPAN>*&nbsp; &nbsp; &nbsp; &nbsp;i have User1&nbsp; and&nbsp;User2<BR />&nbsp; &nbsp; &nbsp;<STRONG> User1</STRONG>&nbsp; </SPAN></P><P><SPAN>*&nbsp; &nbsp; &nbsp; &nbsp;can see 2 countries data out of 15&nbsp;countries i.e IND and US<BR />*&nbsp; &nbsp; &nbsp; &nbsp;User1 can see the <STRONG>US</STRONG> of <STRONG>COGS</STRONG>, but cannot see the <STRONG>India</STRONG>&nbsp;<STRONG>COGS</STRONG><BR /><STRONG>User2</STRONG><BR /></SPAN></P><P><SPAN><STRONG>*&nbsp;&nbsp;</STRONG>&nbsp; &nbsp; Can See all the all data</SPAN></P><P><SPAN>Please refer below table&nbsp;</SPAN></P><P><STRONG>Country&nbsp;</STRONG></P><TABLE><TBODY><TR><TD><STRONG>Country&nbsp; &nbsp;</STRONG></TD><TD><STRONG>Product&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</STRONG></TD><TD><STRONG>Region</STRONG></TD><TD><STRONG>info</STRONG></TD></TR><TR><TD>IND</TD><TD>BOOK</TD><TD>E</TD><TD>ABC</TD></TR><TR><TD>UAE</TD><TD>PEN</TD><TD>W</TD><TD>XYZ</TD></TR><TR><TD>US</TD><TD>BAG</TD><TD>N</TD><TD>XYZ</TD></TR><TR><TD>UK</TD><TD>PHONE</TD><TD>C</TD><TD>XHD</TD></TR><TR><TD>PAK</TD><TD>LONG&nbsp;BOOK</TD><TD>E</TD><TD>XJZ</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>Sales&nbsp;&nbsp;</STRONG></P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>COGS</STRONG></TD><TD><STRONG>SALES</STRONG></TD></TR><TR><TD>100</TD><TD>10</TD></TR><TR><TD>200</TD><TD>20</TD></TR><TR><TD>300</TD><TD>30</TD></TR><TR><TD>400</TD><TD>40</TD></TR><TR><TD>500</TD><TD>50</TD></TR></TBODY></TABLE><P>.</P><P><STRONG>Output</STRONG></P><P>When <STRONG>User1</STRONG> login he should see below table</P><TABLE><TBODY><TR><TD><STRONG>Country</STRONG></TD><TD><STRONG>Product</STRONG></TD><TD><STRONG>Region</STRONG></TD><TD><STRONG>&nbsp;info</STRONG></TD><TD><STRONG>COGS</STRONG></TD><TD><STRONG>SALES</STRONG></TD></TR><TR><TD>IND</TD><TD>BOOK</TD><TD>E</TD><TD>ABC</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>UAE</TD><TD>PEN</TD><TD>W</TD><TD>XYZ</TD><TD>200</TD><TD>20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When <STRONG>User2</STRONG> login he should see below table</P><TABLE><TBODY><TR><TD><STRONG>Country</STRONG></TD><TD><STRONG>&nbsp;Product</STRONG></TD><TD><STRONG>Region</STRONG></TD><TD><STRONG>info</STRONG></TD><TD><STRONG>COGS</STRONG></TD><TD><STRONG>SALES</STRONG></TD></TR><TR><TD>IND</TD><TD>BOOK</TD><TD>E</TD><TD>ABC</TD><TD>100</TD><TD>10</TD></TR><TR><TD>UAE</TD><TD>PEN</TD><TD>W</TD><TD>XYZ</TD><TD>200</TD><TD>20</TD></TR><TR><TD>US</TD><TD>BAG</TD><TD>N</TD><TD>XYZ</TD><TD>300</TD><TD>30</TD></TR><TR><TD>UK</TD><TD>PHONE</TD><TD>C</TD><TD>XHD</TD><TD>400</TD><TD>40</TD></TR><TR><TD>PAK</TD><TD>LONG&nbsp;BOOK</TD><TD>E</TD><TD>XJZ</TD><TD>500</TD><TD>50</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 21:38:33 GMT Jacob 2024-11-16T21:38:33Z https://community.qlik.com/t5/App-Development/Section-Access-Combining-Field-Reduction-and-OMIT/m-p/1527593#M40475 <P>Hi All</P><P>I have below&nbsp;Requirement in section access.</P><P><STRONG><SPAN>Requirement&nbsp;</SPAN></STRONG></P><P><SPAN>*&nbsp; &nbsp; &nbsp; &nbsp;i have User1&nbsp; and&nbsp;User2<BR />&nbsp; &nbsp; &nbsp;<STRONG> User1</STRONG>&nbsp; </SPAN></P><P><SPAN>*&nbsp; &nbsp; &nbsp; &nbsp;can see 2 countries data out of 15&nbsp;countries i.e IND and US<BR />*&nbsp; &nbsp; &nbsp; &nbsp;User1 can see the <STRONG>US</STRONG> of <STRONG>COGS</STRONG>, but cannot see the <STRONG>India</STRONG>&nbsp;<STRONG>COGS</STRONG><BR /><STRONG>User2</STRONG><BR /></SPAN></P><P><SPAN><STRONG>*&nbsp;&nbsp;</STRONG>&nbsp; &nbsp; Can See all the all data</SPAN></P><P><SPAN>Please refer below table&nbsp;</SPAN></P><P><STRONG>Country&nbsp;</STRONG></P><TABLE><TBODY><TR><TD><STRONG>Country&nbsp; &nbsp;</STRONG></TD><TD><STRONG>Product&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</STRONG></TD><TD><STRONG>Region</STRONG></TD><TD><STRONG>info</STRONG></TD></TR><TR><TD>IND</TD><TD>BOOK</TD><TD>E</TD><TD>ABC</TD></TR><TR><TD>UAE</TD><TD>PEN</TD><TD>W</TD><TD>XYZ</TD></TR><TR><TD>US</TD><TD>BAG</TD><TD>N</TD><TD>XYZ</TD></TR><TR><TD>UK</TD><TD>PHONE</TD><TD>C</TD><TD>XHD</TD></TR><TR><TD>PAK</TD><TD>LONG&nbsp;BOOK</TD><TD>E</TD><TD>XJZ</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>Sales&nbsp;&nbsp;</STRONG></P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>COGS</STRONG></TD><TD><STRONG>SALES</STRONG></TD></TR><TR><TD>100</TD><TD>10</TD></TR><TR><TD>200</TD><TD>20</TD></TR><TR><TD>300</TD><TD>30</TD></TR><TR><TD>400</TD><TD>40</TD></TR><TR><TD>500</TD><TD>50</TD></TR></TBODY></TABLE><P>.</P><P><STRONG>Output</STRONG></P><P>When <STRONG>User1</STRONG> login he should see below table</P><TABLE><TBODY><TR><TD><STRONG>Country</STRONG></TD><TD><STRONG>Product</STRONG></TD><TD><STRONG>Region</STRONG></TD><TD><STRONG>&nbsp;info</STRONG></TD><TD><STRONG>COGS</STRONG></TD><TD><STRONG>SALES</STRONG></TD></TR><TR><TD>IND</TD><TD>BOOK</TD><TD>E</TD><TD>ABC</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>UAE</TD><TD>PEN</TD><TD>W</TD><TD>XYZ</TD><TD>200</TD><TD>20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When <STRONG>User2</STRONG> login he should see below table</P><TABLE><TBODY><TR><TD><STRONG>Country</STRONG></TD><TD><STRONG>&nbsp;Product</STRONG></TD><TD><STRONG>Region</STRONG></TD><TD><STRONG>info</STRONG></TD><TD><STRONG>COGS</STRONG></TD><TD><STRONG>SALES</STRONG></TD></TR><TR><TD>IND</TD><TD>BOOK</TD><TD>E</TD><TD>ABC</TD><TD>100</TD><TD>10</TD></TR><TR><TD>UAE</TD><TD>PEN</TD><TD>W</TD><TD>XYZ</TD><TD>200</TD><TD>20</TD></TR><TR><TD>US</TD><TD>BAG</TD><TD>N</TD><TD>XYZ</TD><TD>300</TD><TD>30</TD></TR><TR><TD>UK</TD><TD>PHONE</TD><TD>C</TD><TD>XHD</TD><TD>400</TD><TD>40</TD></TR><TR><TD>PAK</TD><TD>LONG&nbsp;BOOK</TD><TD>E</TD><TD>XJZ</TD><TD>500</TD><TD>50</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 21:38:33 GMT https://community.qlik.com/t5/App-Development/Section-Access-Combining-Field-Reduction-and-OMIT/m-p/1527593#M40475 Jacob 2024-11-16T21:38:33Z