https://community.qlik.com/t5/QlikView/Section-Access-to-show-partial-data/m-p/1894815#M1217474 <P>Hi All,</P> <P>I have a scenario that I need to implement using section Access:</P> <P>My data contains the following:</P> <TABLE border="1" width="76.56249750657864%"> <TBODY> <TR> <TD width="25%">Key</TD> <TD width="25%">Vendor</TD> <TD width="25%">Sales Amount</TD> <TD width="12.5%">Units</TD> </TR> <TR> <TD width="25%">1</TD> <TD width="25%">ABC</TD> <TD width="25%">20</TD> <TD width="12.5%">2</TD> </TR> <TR> <TD width="25%">2</TD> <TD width="25%">XYZ</TD> <TD width="25%">100</TD> <TD width="12.5%">50</TD> </TR> <TR> <TD width="25%">3</TD> <TD width="25%">KLM</TD> <TD width="25%">50</TD> <TD width="12.5%">20</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I have a User-Vendor mapping:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%">User</TD> <TD width="50%">Vendor</TD> </TR> <TR> <TD width="50%">mno.1</TD> <TD width="50%">ABC</TD> </TR> <TR> <TD width="50%">ijk.1</TD> <TD width="50%">XYZ</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>When a user, for example, 'mno.1' logs in, application shows the below:</P> <UL> <LI>His own vendor's entire data.</LI> <LI>Complete data for other vendor data for a certain column but 0 for the rest.</LI> </UL> <P>In our case, it should finally show:</P> <P>Sum of Units = 2+50+20=72</P> <P>Sum of Sales Amount = 20+0+0=20</P> <P>&nbsp;</P> <P>Is this achievable? Please help</P> <P>Thanks in advance.</P> Fri, 18 Feb 2022 12:29:37 GMT mansi_dv 2022-02-18T12:29:37Z https://community.qlik.com/t5/QlikView/Section-Access-to-show-partial-data/m-p/1894815#M1217474 <P>Hi All,</P> <P>I have a scenario that I need to implement using section Access:</P> <P>My data contains the following:</P> <TABLE border="1" width="76.56249750657864%"> <TBODY> <TR> <TD width="25%">Key</TD> <TD width="25%">Vendor</TD> <TD width="25%">Sales Amount</TD> <TD width="12.5%">Units</TD> </TR> <TR> <TD width="25%">1</TD> <TD width="25%">ABC</TD> <TD width="25%">20</TD> <TD width="12.5%">2</TD> </TR> <TR> <TD width="25%">2</TD> <TD width="25%">XYZ</TD> <TD width="25%">100</TD> <TD width="12.5%">50</TD> </TR> <TR> <TD width="25%">3</TD> <TD width="25%">KLM</TD> <TD width="25%">50</TD> <TD width="12.5%">20</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I have a User-Vendor mapping:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%">User</TD> <TD width="50%">Vendor</TD> </TR> <TR> <TD width="50%">mno.1</TD> <TD width="50%">ABC</TD> </TR> <TR> <TD width="50%">ijk.1</TD> <TD width="50%">XYZ</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>When a user, for example, 'mno.1' logs in, application shows the below:</P> <UL> <LI>His own vendor's entire data.</LI> <LI>Complete data for other vendor data for a certain column but 0 for the rest.</LI> </UL> <P>In our case, it should finally show:</P> <P>Sum of Units = 2+50+20=72</P> <P>Sum of Sales Amount = 20+0+0=20</P> <P>&nbsp;</P> <P>Is this achievable? Please help</P> <P>Thanks in advance.</P> Fri, 18 Feb 2022 12:29:37 GMT https://community.qlik.com/t5/QlikView/Section-Access-to-show-partial-data/m-p/1894815#M1217474 mansi_dv 2022-02-18T12:29:37Z