topic Help in script in QlikView https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1392802#M612120 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>below is my pivot data. </P><P>hierarchy is Org name-&gt;VP-&gt;staff-&gt;Manager-&gt;student</P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1378159-182626/pivot.jpg"><IMG alt="pivot.jpg" class="jive-image image-1" height="214" src="https://community.qlik.com/legacyfs/online/185019_pivot.jpg" width="188" /></A></P><P>In pivot table(qliksense) i want&nbsp; the name shields to be displayed only once even though he is part of other columns</P><P></P><P>Below is my load script.</P><P>Table1:</P><P>Orgname,&nbsp; VP, Student_no</P><P>from ..</P><P>left keep(Table1)</P><P>Table2</P><P>Manager,Student ,Student_no,Staff</P><P></P><P>from...</P><P>Thanks,</P><P>Raghav</P></BODY></HTML> Wed, 29 Nov 2017 07:22:23 GMT Anonymous 2017-11-29T07:22:23Z Help in script https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1392802#M612120 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>below is my pivot data. </P><P>hierarchy is Org name-&gt;VP-&gt;staff-&gt;Manager-&gt;student</P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1378159-182626/pivot.jpg"><IMG alt="pivot.jpg" class="jive-image image-1" height="214" src="https://community.qlik.com/legacyfs/online/185019_pivot.jpg" width="188" /></A></P><P>In pivot table(qliksense) i want&nbsp; the name shields to be displayed only once even though he is part of other columns</P><P></P><P>Below is my load script.</P><P>Table1:</P><P>Orgname,&nbsp; VP, Student_no</P><P>from ..</P><P>left keep(Table1)</P><P>Table2</P><P>Manager,Student ,Student_no,Staff</P><P></P><P>from...</P><P>Thanks,</P><P>Raghav</P></BODY></HTML> Wed, 29 Nov 2017 07:22:23 GMT https://community.qlik.com/t5/QlikView/Help-in-script/m-p/1392802#M612120 Anonymous 2017-11-29T07:22:23Z