topic ABC(Pareto select) with restriction in QlikView https://community.qlik.com/t5/QlikView/ABC-Pareto-select-with-restriction/m-p/1276535#M400879 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>i have a question.</P><P><STRONG>1.</STRONG> ABC(Pareto select) without restriction working good. Please see attachment files - ABC_WithoutRestriction.qvw</P><P></P><P><STRONG>2.</STRONG> ABC(Pareto select) with restriction don't working good. Please see attachment file - ABC_WithRestriction.qvw</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>Section Access;</P> <P>LOAD * INLINE [</P> <P>ACCESS,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USERID,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PASSWORD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RESTRICTION_ID</P> <P>ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P> <P>ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P> <P>USER,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USER_01,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USER_01,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P> <P>];</P> <P>Section Application;</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>I need to working ABC(Pareto select) with restriction - ABC_WithRestriction.qvw.</P><P>Please help me.</P></BODY></HTML> Mon, 13 Mar 2017 09:18:19 GMT 2017-03-13T09:18:19Z ABC(Pareto select) with restriction https://community.qlik.com/t5/QlikView/ABC-Pareto-select-with-restriction/m-p/1276535#M400879 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>i have a question.</P><P><STRONG>1.</STRONG> ABC(Pareto select) without restriction working good. Please see attachment files - ABC_WithoutRestriction.qvw</P><P></P><P><STRONG>2.</STRONG> ABC(Pareto select) with restriction don't working good. Please see attachment file - ABC_WithRestriction.qvw</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>Section Access;</P> <P>LOAD * INLINE [</P> <P>ACCESS,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USERID,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PASSWORD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RESTRICTION_ID</P> <P>ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P> <P>ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P> <P>USER,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USER_01,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USER_01,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P> <P>];</P> <P>Section Application;</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>I need to working ABC(Pareto select) with restriction - ABC_WithRestriction.qvw.</P><P>Please help me.</P></BODY></HTML> Mon, 13 Mar 2017 09:18:19 GMT https://community.qlik.com/t5/QlikView/ABC-Pareto-select-with-restriction/m-p/1276535#M400879 2017-03-13T09:18:19Z