topic Re: pivot function help in QlikView

topic Re: pivot function help in QlikView https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482602#M1123937 <HTML><HEAD></HEAD><BODY><P>Try to use Cross table...........</P></BODY></HTML> Wed, 08 Jan 2014 12:11:14 GMT 2014-01-08T12:11:14Z pivot function help https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482600#M1123935 <HTML><HEAD></HEAD><BODY><P>I have excel sheet I have date and name  row should be act as column..  i need the below output pls find attachment</P><P></P><P></P><P>            </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 2521px;"><TBODY><TR></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1012px;"><TBODY><TR><TD class="xl65" height="20" width="55">sl no</TD><TD class="xl65" style="border-left: none;" width="158">RPO NUMBER</TD><TD class="xl65" style="border-left: none;" width="211">customer</TD><TD class="xl65" style="border-left: none;" width="179">Equipment</TD><TD class="xl65" style="border-left: none;" width="225">delivery date</TD><TD class="xl65" style="border-left: none;" width="184">remarks</TD><TD class="xl65" style="border-left: none;" width="184">Date</TD><TD class="xl65" style="border-left: none;" width="184">Name</TD><TD class="xl65" style="border-left: none;" width="184">Hour</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO 13-14-156</TD><TD class="xl66" style="border-top: none; border-left: none;">Dream plast</TD><TD class="xl66" style="border-top: none; border-left: none;">sprue picker</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;">27/12/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">Ram</TD><TD class="xl66" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl68" height="20" style="border-top: none;">2</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO 13-14-173</TD><TD class="xl66" style="border-top: none; border-left: none;">Dream plast</TD><TD class="xl66" style="border-top: none; border-left: none;">conveying</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;">TO BE STARTED</TD><TD class="xl66" style="border-top: none; border-left: none;">27/12/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">Ram</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD></TR><TR><TD class="xl68" height="20" style="border-top: none;">3</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO 13-14-174</TD><TD class="xl66" style="border-top: none; border-left: none;">Dream plast</TD><TD class="xl66" style="border-top: none; border-left: none;">conveying</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;">TO BE STARTED</TD><TD class="xl66" style="border-top: none; border-left: none;">27/12/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">Ram</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl68" height="20" style="border-top: none;">4</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO-13-14-167</TD><TD class="xl66" style="border-top: none; border-left: none;">poly plastics</TD><TD class="xl66" style="border-top: none; border-left: none;">mtc 140</TD><TD class="xl66" style="border-top: none; border-left: none;">Ready for dispatch</TD><TD class="xl66" style="border-top: none; border-left: none;">progress</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">5</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO 13-14-164</TD><TD class="xl66" style="border-top: none; border-left: none;">poly plastics</TD><TD class="xl69" style="border-left: none;">chiller 2 tr</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl65" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD><TD class="xl65" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">6</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO 13-14-170,171,172</TD><TD class="xl66" style="border-top: none; border-left: none;">poly plastics</TD><TD class="xl66" style="border-left: none;">conveying</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;">PROGRESS</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">7</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO-13-14-177</TD><TD class="xl66" style="border-top: none; border-left: none;">ijl</TD><TD class="xl66" style="border-top: none; border-left: none;">eoat assy</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;">to be started</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">8</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO 13-14-162</TD><TD class="xl66" style="border-top: none; border-left: none;">Kalyx plasti</TD><TD class="xl66" style="border-top: none; border-left: none;">WFR 10zone</TD><TD class="xl66" style="border-top: none; border-left: none;">week 52 reaching at chennai</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">9</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO-13-14-146</TD><TD class="xl66" style="border-top: none; border-left: none;">visteon automotive</TD><TD class="xl66" style="border-top: none; border-left: none;">conveying accessories</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for ETA</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">13</TD><TD class="xl66" style="border-top: none; border-left: none;">NA</TD><TD class="xl66" style="border-top: none; border-left: none;">in house</TD><TD class="xl66" style="border-top: none; border-left: none;">50 ltr HAD</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for CONTROL BOX</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">14</TD><TD class="xl66" style="border-top: none; border-left: none;">NA</TD><TD class="xl66" style="border-top: none; border-left: none;">in house</TD><TD class="xl66" style="border-top: none; border-left: none;">100 ltr HAD</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for CONTROL BOX</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;">27/12/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">mur</TD><TD class="xl66" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">15</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO-13-14-157</TD><TD class="xl66" style="border-top: none; border-left: none;">Mahle filter systems</TD><TD class="xl66" style="border-top: none; border-left: none;">Granulator</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for ETA</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">16</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO-13-14-147</TD><TD class="xl66" style="border-top: none; border-left: none;">PIOLEX</TD><TD class="xl66" style="border-top: none; border-left: none;">CONVEYOR</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for ETA</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;">27/12/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">mur</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">17</TD><TD class="xl66" style="border-top: none; border-left: none;">RPO-13-14-176</TD><TD class="xl66" style="border-top: none; border-left: none;">PIOLEX</TD><TD class="xl66" style="border-top: none; border-left: none;">CONVEYOR</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for ETA</TD><TD class="xl66" style="border-top: none; border-left: none;">waiting for material</TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD><TD class="xl66" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">18</TD><TD class="xl70" style="border-top: none; border-left: none;">RETURNED</TD><TD class="xl70" style="border-top: none; border-left: none;">SL LUMAX</TD><TD class="xl70" style="border-top: none; border-left: none;">eoat assy</TD><TD class="xl71" style="border-top: none; border-left: none;"></TD><TD class="xl71" style="border-top: none; border-left: none;"></TD><TD class="xl71" style="border-top: none; border-left: none;"></TD><TD class="xl71" style="border-top: none; border-left: none;"></TD><TD class="xl71" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="20">19</TD><TD class="xl66" style="border-left: none;">REWORK</TD><TD class="xl66" style="border-left: none;">VALEO</TD><TD class="xl66" style="border-left: none;">eoat assy</TD><TD class="xl67" style="border-left: none;"></TD><TD class="xl67" style="border-left: none;"></TD><TD class="xl67" style="border-left: none;">27/12/2013</TD><TD class="xl67" style="border-left: none;">sam</TD><TD class="xl67" style="border-left: none;">8</TD></TR></TBODY></TABLE><P>RPO NU</P></BODY></HTML> Wed, 08 Jan 2014 12:06:04 GMT https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482600#M1123935 Anonymous 2014-01-08T12:06:04Z Re: pivot function help https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482601#M1123936 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> I don't see the attachment.</P></BODY></HTML> Wed, 08 Jan 2014 12:08:25 GMT https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482601#M1123936 bbi_mba_76 2014-01-08T12:08:25Z Re: pivot function help https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482602#M1123937 <HTML><HEAD></HEAD><BODY><P>Try to use Cross table...........</P></BODY></HTML> Wed, 08 Jan 2014 12:11:14 GMT https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482602#M1123937 2014-01-08T12:11:14Z Re: Re: pivot function help https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482603#M1123938 <HTML><HEAD></HEAD><BODY><P>sorry i missed</P></BODY></HTML> Wed, 08 Jan 2014 12:44:08 GMT https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482603#M1123938 Anonymous 2014-01-08T12:44:08Z Re: pivot function help https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482604#M1123939 <HTML><HEAD></HEAD><BODY><P>I know its cross tab function..but requirment is different one</P></BODY></HTML> Thu, 09 Jan 2014 09:33:00 GMT https://community.qlik.com/t5/QlikView/pivot-function-help/m-p/482604#M1123939 Anonymous 2014-01-09T09:33:00Z