topic Need data restriction help in QlikView https://community.qlik.com/t5/QlikView/Need-data-restriction-help/m-p/264417#M707970 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have below user table and I have attached sample reporting hierarachy. Need help to build identification code to restrict user by considering multiple data restriction fields.</P><P></P><P></P><P></P><P></P><P>section Access;</P><P>LOAD * INLINE [&nbsp;&nbsp; </P><P>ACCESS, USERID, PASSWORD,</P><P>USER&nbsp;&nbsp;&nbsp; Malinga&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Odumbe&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Yosuf&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Manager</P><P>USER&nbsp;&nbsp;&nbsp; Praveen&nbsp;&nbsp;&nbsp; Manager</P><P>USER&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Manager</P><P>USER&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; SManager</P><P>USER&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; SManager</P><P>ADMIN&nbsp;&nbsp;&nbsp; JoyKing&nbsp;&nbsp;&nbsp; Exec</P><P> ]; </P><P></P><P>Reporting_Hierarchy Table:</P><P>AgentName&nbsp;&nbsp;&nbsp; CoachName&nbsp;&nbsp;&nbsp; ManagerName&nbsp;&nbsp;&nbsp; SManagerName&nbsp;&nbsp;&nbsp; ExecName</P><P>Vicky&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P>Raj&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P>Joseph&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P>Rohit&nbsp;&nbsp;&nbsp; Malinga&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Dhoni&nbsp;&nbsp;&nbsp; Malinga&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Ponting&nbsp;&nbsp;&nbsp; Yosuf&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Fleming&nbsp;&nbsp;&nbsp; Yosuf&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Virat&nbsp;&nbsp;&nbsp; Odumbe&nbsp;&nbsp;&nbsp; Praveen&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P></P><P></P><P>So, Ex: Prasad should be able to access Coach Sachin data and all his agents data.</P><P>Sunil should be able to access coach Malinga and Yosuf data and all his agents data.</P><P></P><P></P><P></P><P>Thanks in advance,</P><P></P><P>Keerthy</P></BODY></HTML> Wed, 11 Jan 2012 04:11:18 GMT 2012-01-11T04:11:18Z Need data restriction help https://community.qlik.com/t5/QlikView/Need-data-restriction-help/m-p/264417#M707970 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have below user table and I have attached sample reporting hierarachy. Need help to build identification code to restrict user by considering multiple data restriction fields.</P><P></P><P></P><P></P><P></P><P>section Access;</P><P>LOAD * INLINE [&nbsp;&nbsp; </P><P>ACCESS, USERID, PASSWORD,</P><P>USER&nbsp;&nbsp;&nbsp; Malinga&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Odumbe&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Yosuf&nbsp;&nbsp;&nbsp; Coach</P><P>USER&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Manager</P><P>USER&nbsp;&nbsp;&nbsp; Praveen&nbsp;&nbsp;&nbsp; Manager</P><P>USER&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Manager</P><P>USER&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; SManager</P><P>USER&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; SManager</P><P>ADMIN&nbsp;&nbsp;&nbsp; JoyKing&nbsp;&nbsp;&nbsp; Exec</P><P> ]; </P><P></P><P>Reporting_Hierarchy Table:</P><P>AgentName&nbsp;&nbsp;&nbsp; CoachName&nbsp;&nbsp;&nbsp; ManagerName&nbsp;&nbsp;&nbsp; SManagerName&nbsp;&nbsp;&nbsp; ExecName</P><P>Vicky&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P>Raj&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P>Joseph&nbsp;&nbsp;&nbsp; Sachin&nbsp;&nbsp;&nbsp; Prasad&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P>Rohit&nbsp;&nbsp;&nbsp; Malinga&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Dhoni&nbsp;&nbsp;&nbsp; Malinga&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Ponting&nbsp;&nbsp;&nbsp; Yosuf&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Fleming&nbsp;&nbsp;&nbsp; Yosuf&nbsp;&nbsp;&nbsp; Sunil&nbsp;&nbsp;&nbsp; Srinath&nbsp;&nbsp;&nbsp; JoyKing</P><P>Virat&nbsp;&nbsp;&nbsp; Odumbe&nbsp;&nbsp;&nbsp; Praveen&nbsp;&nbsp;&nbsp; Venkatesh&nbsp;&nbsp;&nbsp; JoyKing</P><P></P><P></P><P>So, Ex: Prasad should be able to access Coach Sachin data and all his agents data.</P><P>Sunil should be able to access coach Malinga and Yosuf data and all his agents data.</P><P></P><P></P><P></P><P>Thanks in advance,</P><P></P><P>Keerthy</P></BODY></HTML> Wed, 11 Jan 2012 04:11:18 GMT https://community.qlik.com/t5/QlikView/Need-data-restriction-help/m-p/264417#M707970 2012-01-11T04:11:18Z