topic Section Access. Adding Reduction Field in App Development

topic Section Access. Adding Reduction Field in App Development https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672325#M50868 <P>I have a section access CSV setup like the following. I need to open up just a bit of User2's data to User1. There is another field on the same table ( It happens to be a key) that will work. Let's call it Reduction2.  Fig1 works fine for what I need it to do normally but I don't want to open up all of User2's data to User 1. Will Fig2 work or is my logic off? Will User 1 be able to see his normal data and also data where ACCOUNT_2 is true? ACCOUNT_2 is normally only visible to USER 2. I am having trouble testing it because of my user access. Also, any suggestions? I am one month into Qlik Sense. </P><P>Fig1</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%">ACCESS</TD><TD width="25%">USERID</TD><TD width="25%">REDUCTION1</TD><TD width="25%">OMIT</TD></TR><TR><TD width="25%">USER1</TD><TD width="25%">DOMAIN\USER1</TD><TD width="25%">USER1</TD><TD width="25%"> </TD></TR><TR><TD width="25%">USER2</TD><TD width="25%">DOMAIN\USER2</TD><TD width="25%">USER2</TD><TD width="25%"> </TD></TR><TR><TD width="25%">USER3</TD><TD width="25%">DOMAIN\USER3</TD><TD width="25%">USER3</TD><TD width="25%"> </TD></TR></TBODY></TABLE><P> </P><P>Fig2</P><TABLE border="1" width="100%"><TBODY><TR><TD width="20%" height="24px">ACCESS</TD><TD width="20%" height="24px">USERID</TD><TD width="20%" height="24px">REDUCTION1</TD><TD width="20%" height="24px">REDUCTION2</TD><TD width="20%" height="24px">OMIT</TD></TR><TR><TD width="20%" height="24px">USER1</TD><TD width="20%" height="24px">DOMAIN\USER1</TD><TD width="20%" height="24px">USER1</TD><TD width="20%" height="24px"> </TD><TD width="20%" height="24px"> </TD></TR><TR><TD width="20%" height="24px">USER2</TD><TD width="20%" height="24px">DOMAIN\USER2</TD><TD width="20%" height="24px">USER2</TD><TD width="20%" height="24px"> </TD><TD width="20%" height="24px"> </TD></TR><TR><TD>USER3</TD><TD>DOMAIN\USER3</TD><TD>USER3</TD><TD> </TD><TD> </TD></TR><TR><TD width="20%" height="24px">USER1</TD><TD width="20%" height="24px">DOMAIN\USER1</TD><TD width="20%" height="24px"> </TD><TD width="20%" height="24px">ACCOUNT_2</TD><TD width="20%" height="24px"> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><P>Thanks!</P> Sat, 16 Nov 2024 19:10:40 GMT smithc2005 2024-11-16T19:10:40Z Section Access. Adding Reduction Field https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672325#M50868 <P>I have a section access CSV setup like the following. I need to open up just a bit of User2's data to User1. There is another field on the same table ( It happens to be a key) that will work. Let's call it Reduction2.  Fig1 works fine for what I need it to do normally but I don't want to open up all of User2's data to User 1. Will Fig2 work or is my logic off? Will User 1 be able to see his normal data and also data where ACCOUNT_2 is true? ACCOUNT_2 is normally only visible to USER 2. I am having trouble testing it because of my user access. Also, any suggestions? I am one month into Qlik Sense. </P><P>Fig1</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%">ACCESS</TD><TD width="25%">USERID</TD><TD width="25%">REDUCTION1</TD><TD width="25%">OMIT</TD></TR><TR><TD width="25%">USER1</TD><TD width="25%">DOMAIN\USER1</TD><TD width="25%">USER1</TD><TD width="25%"> </TD></TR><TR><TD width="25%">USER2</TD><TD width="25%">DOMAIN\USER2</TD><TD width="25%">USER2</TD><TD width="25%"> </TD></TR><TR><TD width="25%">USER3</TD><TD width="25%">DOMAIN\USER3</TD><TD width="25%">USER3</TD><TD width="25%"> </TD></TR></TBODY></TABLE><P> </P><P>Fig2</P><TABLE border="1" width="100%"><TBODY><TR><TD width="20%" height="24px">ACCESS</TD><TD width="20%" height="24px">USERID</TD><TD width="20%" height="24px">REDUCTION1</TD><TD width="20%" height="24px">REDUCTION2</TD><TD width="20%" height="24px">OMIT</TD></TR><TR><TD width="20%" height="24px">USER1</TD><TD width="20%" height="24px">DOMAIN\USER1</TD><TD width="20%" height="24px">USER1</TD><TD width="20%" height="24px"> </TD><TD width="20%" height="24px"> </TD></TR><TR><TD width="20%" height="24px">USER2</TD><TD width="20%" height="24px">DOMAIN\USER2</TD><TD width="20%" height="24px">USER2</TD><TD width="20%" height="24px"> </TD><TD width="20%" height="24px"> </TD></TR><TR><TD>USER3</TD><TD>DOMAIN\USER3</TD><TD>USER3</TD><TD> </TD><TD> </TD></TR><TR><TD width="20%" height="24px">USER1</TD><TD width="20%" height="24px">DOMAIN\USER1</TD><TD width="20%" height="24px"> </TD><TD width="20%" height="24px">ACCOUNT_2</TD><TD width="20%" height="24px"> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><P>Thanks!</P> Sat, 16 Nov 2024 19:10:40 GMT https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672325#M50868 smithc2005 2024-11-16T19:10:40Z Re: Section Access. Adding Reduction Field https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672327#M50869 <P>Hi Dear<SPAN class="UserName lia-user-name lia-user-rank-Registered-User lia-component-message-view-widget-author-username"><A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/105304" target="_self"><SPAN class=""> smithc2005</SPAN></A></SPAN></P><P>You can see this article, is wonderfull to solve your request</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872 " target="_blank" rel="noopener">https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872 </A></P> Tue, 04 Feb 2020 22:44:58 GMT https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672327#M50869 marcos_herrera 2020-02-04T22:44:58Z Re: Section Access. Adding Reduction Field https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672329#M50870 <P>Thank you, but the above link did not work on my end. </P><P> </P> Tue, 04 Feb 2020 22:48:14 GMT https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672329#M50870 smithc2005 2020-02-04T22:48:14Z Re: Section Access. Adding Reduction Field https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672330#M50871 <P>Is this it?</P><P> </P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872</A></P> Tue, 04 Feb 2020 22:49:20 GMT https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672330#M50871 smithc2005 2020-02-04T22:49:20Z Re: Section Access. Adding Reduction Field https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672331#M50872 <P>Whoops! I got it. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P> </P> Tue, 04 Feb 2020 22:50:37 GMT https://community.qlik.com/t5/App-Development/Section-Access-Adding-Reduction-Field/m-p/1672331#M50872 smithc2005 2020-02-04T22:50:37Z