topic help in QlikView https://community.qlik.com/t5/QlikView/help/m-p/751514#M267966 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 64px;"><TBODY><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt; width: 48pt;" width="64">DEPT</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX1</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX2</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX3</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX4</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX5</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX6</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX7</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX8</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX9</TD></TR></TBODY></TABLE><P>i want to assign the xxx1, xxx2,xxx3 as IT dept ,xxx4,xxx5,xxx6 as CSE dept,xxx7.xxx8,xxx9 as ECE dept.</P><P></P><P>all these&nbsp; assigned IT dept, CSE dept, ECE dept has to be assigned under DEPT.</P><P></P><P>can you help me on load script how to do this</P></BODY></HTML> Thu, 19 Mar 2015 13:39:26 GMT manoranjan_d 2015-03-19T13:39:26Z help https://community.qlik.com/t5/QlikView/help/m-p/751514#M267966 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 64px;"><TBODY><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt; width: 48pt;" width="64">DEPT</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX1</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX2</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX3</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX4</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX5</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX6</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX7</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX8</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">XXX9</TD></TR></TBODY></TABLE><P>i want to assign the xxx1, xxx2,xxx3 as IT dept ,xxx4,xxx5,xxx6 as CSE dept,xxx7.xxx8,xxx9 as ECE dept.</P><P></P><P>all these&nbsp; assigned IT dept, CSE dept, ECE dept has to be assigned under DEPT.</P><P></P><P>can you help me on load script how to do this</P></BODY></HTML> Thu, 19 Mar 2015 13:39:26 GMT https://community.qlik.com/t5/QlikView/help/m-p/751514#M267966 manoranjan_d 2015-03-19T13:39:26Z Re: help https://community.qlik.com/t5/QlikView/help/m-p/751515#M267967 <HTML><HEAD></HEAD><BODY><P>DepartmentStructure:</P><P>load * inline</P><P>[DEPT, GROUP, GROUP</P><P><SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN>XXX1, IT Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN></P><P>DEPTXXX2, IT Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN> </P><P>DEPTXXX3, IT Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN> </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">DEPTXXX4, CSE Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">DEPTXXX5, CSE Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">DEPTXXX6, CSE Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">DEPTXXX7, ECE Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">DEPTXXX8, ECE Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">DEPTXXX9, ECE Dept, <SPAN style="font-size: 13.3333330154419px;">DEPT</SPAN></SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333330154419px;">];<BR /></SPAN></P></BODY></HTML> Thu, 19 Mar 2015 15:07:14 GMT https://community.qlik.com/t5/QlikView/help/m-p/751515#M267967 Roop 2015-03-19T15:07:14Z