topic Re: CLUBING THE DATA in QlikView https://community.qlik.com/t5/QlikView/CLUBING-THE-DATA/m-p/821072#M289437 <HTML><HEAD></HEAD><BODY><P>try this,</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-1YEAR<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-2YEAR<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-3YEAR<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-4YEAR as ITDept</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 17 Mar 2015 15:37:18 GMT buzzy996 2015-03-17T15:37:18Z CLUBING THE DATA https://community.qlik.com/t5/QlikView/CLUBING-THE-DATA/m-p/821071#M289436 <HTML><HEAD></HEAD><BODY><P>hi below is my example data.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 219pt;" width="291"><TBODY><TR style="height: 15.0pt;"><TD class="xl63" height="20" style="height: 15.0pt; width: 46pt;" width="61">IT</TD><TD class="xl63" style="border-left: none; width: 54pt;" width="72">CSE</TD><TD class="xl63" style="border-left: none; width: 65pt;" width="86">ROBO</TD><TD class="xl63" style="border-left: none; width: 54pt;" width="72">ECE</TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none;">IT-1YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">CSE-1YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ROBO-1YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ECE-1YEAR</TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none;">IT-2YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">CSE-2YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ROBO-2YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ECE-2YEAR</TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none;">IT-3YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">CSE-3YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ROBO-3YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ECE-3YEAR</TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none;">IT-4YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">CSE-4YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ROBO-4YEAR</TD><TD class="xl64" style="border-top: none; border-left: none;">ECE-4YEAR</TD></TR></TBODY></TABLE><P></P><P>how to club these IT years( 1yr, 2yr, 3yr and 4yr) under one field of IT Dept, like the same thing has to be done for other depts.</P><P></P><P>can you help me, how&nbsp; to club all these(years) in one dept in load script. </P></BODY></HTML> Tue, 17 Mar 2015 14:58:05 GMT https://community.qlik.com/t5/QlikView/CLUBING-THE-DATA/m-p/821071#M289436 manoranjan_d 2015-03-17T14:58:05Z Re: CLUBING THE DATA https://community.qlik.com/t5/QlikView/CLUBING-THE-DATA/m-p/821072#M289437 <HTML><HEAD></HEAD><BODY><P>try this,</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-1YEAR<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-2YEAR<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-3YEAR<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&amp;'-'&amp;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IT-4YEAR as ITDept</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 17 Mar 2015 15:37:18 GMT https://community.qlik.com/t5/QlikView/CLUBING-THE-DATA/m-p/821072#M289437 buzzy996 2015-03-17T15:37:18Z