topic Re: Loading Crosstable in QlikView https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15569#M2521 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Avinash!!</P></BODY></HTML> Wed, 11 Apr 2018 09:26:50 GMT sumeet-vaidya 2018-04-11T09:26:50Z Loading Crosstable https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15566#M2518 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Kindly help in getting the below output from the attached excel file. PFA</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="740"><TBODY><TR><TD class="xl77" height="18" width="98">Customer</TD><TD class="xl78" style="border-left: none;" width="128">Market Sub Segment</TD><TD class="xl78" style="border-left: none;" width="139">Estimate Version</TD><TD class="xl78" style="border-left: none;" width="56">Month</TD><TD class="xl79" style="border-left: none;" width="69">A</TD><TD class="xl79" style="border-left: none;" width="56">B</TD><TD class="xl79" style="border-left: none;" width="69">C</TD><TD class="xl79" style="border-left: none;" width="56">D</TD><TD class="xl80" style="border-left: none;" width="69">E</TD></TR><TR><TD class="xl68" height="17">0000017533</TD><TD class="xl67" style="border-left: none;">Pulp</TD><TD class="xl67" style="border-left: none;">002</TD><TD class="xl76" style="border-left: none;">AUG</TD><TD class="xl70" style="border-left: none;">1</TD><TD class="xl70" style="border-left: none;">2</TD><TD class="xl70" style="border-left: none;">3</TD><TD class="xl69" style="border-left: none;">4</TD><TD class="xl71" style="border-left: none;">5</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017533</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">002</TD><TD class="xl75" style="border-top: none; border-left: none;">SEP</TD><TD class="xl74" style="border-top: none; border-left: none;">6</TD><TD class="xl73" style="border-top: none; border-left: none;">7</TD><TD class="xl74" style="border-top: none; border-left: none;">8</TD><TD class="xl73" style="border-top: none; border-left: none;">9</TD><TD class="xl81" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017533</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">002</TD><TD class="xl72" style="border-top: none; border-left: none;">OCT</TD><TD class="xl73" style="border-top: none; border-left: none;">11</TD><TD class="xl74" style="border-top: none; border-left: none;">12</TD><TD class="xl73" style="border-top: none; border-left: none;">13</TD><TD class="xl74" style="border-top: none; border-left: none;">14</TD><TD class="xl82" style="border-top: none; border-left: none;">15</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017533</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">003</TD><TD class="xl72" style="border-top: none; border-left: none;">AUG</TD><TD class="xl73" style="border-top: none; border-left: none;">1</TD><TD class="xl73" style="border-top: none; border-left: none;">2</TD><TD class="xl73" style="border-top: none; border-left: none;">3</TD><TD class="xl74" style="border-top: none; border-left: none;">4</TD><TD class="xl82" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017533</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">003</TD><TD class="xl75" style="border-top: none; border-left: none;">SEP</TD><TD class="xl74" style="border-top: none; border-left: none;">6</TD><TD class="xl73" style="border-top: none; border-left: none;">7</TD><TD class="xl74" style="border-top: none; border-left: none;">8</TD><TD class="xl73" style="border-top: none; border-left: none;">9</TD><TD class="xl81" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017533</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">003</TD><TD class="xl72" style="border-top: none; border-left: none;">OCT</TD><TD class="xl73" style="border-top: none; border-left: none;">11</TD><TD class="xl74" style="border-top: none; border-left: none;">12</TD><TD class="xl73" style="border-top: none; border-left: none;">13</TD><TD class="xl74" style="border-top: none; border-left: none;">14</TD><TD class="xl82" style="border-top: none; border-left: none;">15</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017535</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">002</TD><TD class="xl72" style="border-top: none; border-left: none;">AUG</TD><TD class="xl73" style="border-top: none; border-left: none;">1</TD><TD class="xl73" style="border-top: none; border-left: none;">2</TD><TD class="xl73" style="border-top: none; border-left: none;">3</TD><TD class="xl74" style="border-top: none; border-left: none;">4</TD><TD class="xl82" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017535</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">002</TD><TD class="xl75" style="border-top: none; border-left: none;">SEP</TD><TD class="xl74" style="border-top: none; border-left: none;">6</TD><TD class="xl73" style="border-top: none; border-left: none;">7</TD><TD class="xl74" style="border-top: none; border-left: none;">8</TD><TD class="xl73" style="border-top: none; border-left: none;">9</TD><TD class="xl81" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017535</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">002</TD><TD class="xl72" style="border-top: none; border-left: none;">OCT</TD><TD class="xl73" style="border-top: none; border-left: none;">11</TD><TD class="xl74" style="border-top: none; border-left: none;">12</TD><TD class="xl73" style="border-top: none; border-left: none;">13</TD><TD class="xl74" style="border-top: none; border-left: none;">14</TD><TD class="xl82" style="border-top: none; border-left: none;">15</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017535</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">003</TD><TD class="xl72" style="border-top: none; border-left: none;">AUG</TD><TD class="xl73" style="border-top: none; border-left: none;">1</TD><TD class="xl73" style="border-top: none; border-left: none;">2</TD><TD class="xl73" style="border-top: none; border-left: none;">3</TD><TD class="xl74" style="border-top: none; border-left: none;">4</TD><TD class="xl82" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">0000017535</TD><TD class="xl63" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl63" style="border-top: none; border-left: none;">003</TD><TD class="xl75" style="border-top: none; border-left: none;">SEP</TD><TD class="xl74" style="border-top: none; border-left: none;">6</TD><TD class="xl73" style="border-top: none; border-left: none;">7</TD><TD class="xl74" style="border-top: none; border-left: none;">8</TD><TD class="xl73" style="border-top: none; border-left: none;">9</TD><TD class="xl81" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl65" height="18" style="border-top: none;">0000017535</TD><TD class="xl66" style="border-top: none; border-left: none;">Pulp</TD><TD class="xl66" style="border-top: none; border-left: none;">003</TD><TD class="xl83" style="border-top: none; border-left: none;">OCT</TD><TD class="xl84" style="border-top: none; border-left: none;">11</TD><TD class="xl85" style="border-top: none; border-left: none;">12</TD><TD class="xl84" style="border-top: none; border-left: none;">13</TD><TD class="xl85" style="border-top: none; border-left: none;">14</TD><TD class="xl86" style="border-top: none; border-left: none;">15</TD></TR></TBODY></TABLE><P></P><P></P><P><A href="https://community.qlik.com/qlik-users/4003">hic</A>‌ <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P></P><P>Regards</P><P>Sumeet Vaidya</P></BODY></HTML> Wed, 11 Apr 2018 05:21:30 GMT https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15566#M2518 sumeet-vaidya 2018-04-11T05:21:30Z Re: Loading Crosstable https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15567#M2519 <HTML><HEAD></HEAD><BODY><P><EM>check the attached solution </EM></P></BODY></HTML> Wed, 11 Apr 2018 06:44:31 GMT https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15567#M2519 avinashelite 2018-04-11T06:44:31Z Re: Loading Crosstable https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15568#M2520 <HTML><HEAD></HEAD><BODY><P>If you have got the answer mark the correct and helpful answers and close this thread </P></BODY></HTML> Wed, 11 Apr 2018 09:02:04 GMT https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15568#M2520 avinashelite 2018-04-11T09:02:04Z Re: Loading Crosstable https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15569#M2521 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Avinash!!</P></BODY></HTML> Wed, 11 Apr 2018 09:26:50 GMT https://community.qlik.com/t5/QlikView/Loading-Crosstable/m-p/15569#M2521 sumeet-vaidya 2018-04-11T09:26:50Z