topic Crosstable? in QlikView https://community.qlik.com/t5/QlikView/Crosstable/m-p/557501#M208136 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I have below table...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="1101"><TBODY><TR><TD class="xl80" height="61" width="70">OUR PART</TD><TD class="xl81" style="border-left: none;" width="66">MAIN SUPPLIER</TD><TD class="xl82" style="border-left: none;" width="65"> MAIN SUPPLIER PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 01 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 01 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 02 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 02 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 03 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 03 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 04 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 04 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 05 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 05 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 06 Part Number</TD><TD class="xl83" style="border-left: none;" width="68"> SUPPLIER 06 PRICE </TD></TR><TR><TD class="xl76" height="20">ABC</TD><TD class="xl77" style="border-left: none;">MAIN 001</TD><TD class="xl78" style="border-left: none;"> £ 10.00 </TD><TD class="xl77" style="border-left: none;">ABC 01</TD><TD class="xl78" style="border-left: none;"> £ 15.00 </TD><TD class="xl77" style="border-left: none;">ABC 02</TD><TD class="xl78" style="border-left: none;"> £ 8.00 </TD><TD class="xl77" style="border-left: none;">ABC 03</TD><TD class="xl78" style="border-left: none;"> £ 9.00 </TD><TD class="xl77" style="border-left: none;">ABC 04</TD><TD class="xl78" style="border-left: none;"> £ 22.00 </TD><TD class="xl77" style="border-left: none;">ABC 05</TD><TD class="xl78" style="border-left: none;"> £ 21.00 </TD><TD class="xl77" style="border-left: none;">ABC 06</TD><TD class="xl79" style="border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">DEF</TD><TD class="xl68" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 01</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 18.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 02</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 7.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 03</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 13.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 04</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 25.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 05</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 18.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 06</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">GHI</TD><TD class="xl68" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 01</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 02</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 16.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 03</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 04</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 23.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 05</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 17.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 06</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">JKL</TD><TD class="xl68" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 01</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 14.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 02</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 03</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 11.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 04</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 28.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 05</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 16.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 06</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR><TR><TD class="xl72" height="21" style="border-top: none;">MNO</TD><TD class="xl73" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 01</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 13.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 02</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 11.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 03</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 14.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 04</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 30.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 05</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 06</TD><TD class="xl75" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR></TBODY></TABLE><P>and wants resut as below table...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="378"><TBODY><TR><TD class="xl67" height="61" width="39">OUR PART</TD><TD class="xl68" style="border-left: none;" width="66">MAIN SUPPLIER</TD><TD class="xl69" style="border-left: none;" width="64"> MAIN SUPPLIER PRICE </TD><TD class="xl68" style="border-left: none;" width="81">SUPPLIER</TD><TD class="xl68" style="border-left: none;" width="64">SUPPLIER PART Number</TD><TD class="xl82" style="border-left: none;" width="64">SUPPLIER PRICE</TD></TR><TR><TD class="xl78" height="20">ABC</TD><TD class="xl79" style="border-left: none;">MAIN 001</TD><TD class="xl80" style="border-left: none;"> £ 10.00 </TD><TD class="xl79" style="border-left: none;">SUPPLIER 01</TD><TD class="xl79" style="border-left: none;">ABC 01</TD><TD class="xl81" style="border-left: none;"> £ 15.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 18.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 12.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 7.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 16.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 12.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 11.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 9.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 12.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 11.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 22.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 25.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 23.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 28.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 30.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 21.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 18.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 17.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 16.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 15.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 10.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR><TR><TD class="xl74" height="21" style="border-top: none;">MNO</TD><TD class="xl75" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl76" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl75" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl75" style="border-top: none; border-left: none;">MNO 06</TD><TD class="xl77" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR></TBODY></TABLE><P>Excel file enclosed for your reference.</P><P>Please help...</P></BODY></HTML> Mon, 05 Aug 2013 08:37:53 GMT MK_QSL 2013-08-05T08:37:53Z Crosstable? https://community.qlik.com/t5/QlikView/Crosstable/m-p/557501#M208136 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I have below table...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="1101"><TBODY><TR><TD class="xl80" height="61" width="70">OUR PART</TD><TD class="xl81" style="border-left: none;" width="66">MAIN SUPPLIER</TD><TD class="xl82" style="border-left: none;" width="65"> MAIN SUPPLIER PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 01 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 01 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 02 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 02 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 03 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 03 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 04 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 04 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 05 Part Number</TD><TD class="xl82" style="border-left: none;" width="68"> SUPPLIER 05 PRICE </TD><TD class="xl81" style="border-left: none;" width="82">SUPPLIER 06 Part Number</TD><TD class="xl83" style="border-left: none;" width="68"> SUPPLIER 06 PRICE </TD></TR><TR><TD class="xl76" height="20">ABC</TD><TD class="xl77" style="border-left: none;">MAIN 001</TD><TD class="xl78" style="border-left: none;"> £ 10.00 </TD><TD class="xl77" style="border-left: none;">ABC 01</TD><TD class="xl78" style="border-left: none;"> £ 15.00 </TD><TD class="xl77" style="border-left: none;">ABC 02</TD><TD class="xl78" style="border-left: none;"> £ 8.00 </TD><TD class="xl77" style="border-left: none;">ABC 03</TD><TD class="xl78" style="border-left: none;"> £ 9.00 </TD><TD class="xl77" style="border-left: none;">ABC 04</TD><TD class="xl78" style="border-left: none;"> £ 22.00 </TD><TD class="xl77" style="border-left: none;">ABC 05</TD><TD class="xl78" style="border-left: none;"> £ 21.00 </TD><TD class="xl77" style="border-left: none;">ABC 06</TD><TD class="xl79" style="border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">DEF</TD><TD class="xl68" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 01</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 18.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 02</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 7.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 03</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 13.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 04</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 25.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 05</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 18.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">DEF 06</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">GHI</TD><TD class="xl68" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 01</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 02</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 16.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 03</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 04</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 23.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 05</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 17.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">GHI 06</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">JKL</TD><TD class="xl68" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 01</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 14.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 02</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 03</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 11.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 04</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 28.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 05</TD><TD class="xl69" style="border-top: none; border-left: none;"> £ 16.00 </TD><TD class="xl68" style="border-top: none; border-left: none;">JKL 06</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR><TR><TD class="xl72" height="21" style="border-top: none;">MNO</TD><TD class="xl73" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 01</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 13.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 02</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 11.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 03</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 14.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 04</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 30.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 05</TD><TD class="xl74" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl73" style="border-top: none; border-left: none;">MNO 06</TD><TD class="xl75" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR></TBODY></TABLE><P>and wants resut as below table...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="378"><TBODY><TR><TD class="xl67" height="61" width="39">OUR PART</TD><TD class="xl68" style="border-left: none;" width="66">MAIN SUPPLIER</TD><TD class="xl69" style="border-left: none;" width="64"> MAIN SUPPLIER PRICE </TD><TD class="xl68" style="border-left: none;" width="81">SUPPLIER</TD><TD class="xl68" style="border-left: none;" width="64">SUPPLIER PART Number</TD><TD class="xl82" style="border-left: none;" width="64">SUPPLIER PRICE</TD></TR><TR><TD class="xl78" height="20">ABC</TD><TD class="xl79" style="border-left: none;">MAIN 001</TD><TD class="xl80" style="border-left: none;"> £ 10.00 </TD><TD class="xl79" style="border-left: none;">SUPPLIER 01</TD><TD class="xl79" style="border-left: none;">ABC 01</TD><TD class="xl81" style="border-left: none;"> £ 15.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 18.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 12.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 01</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 01</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 7.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 16.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 12.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 02</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 02</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 11.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 9.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 12.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 11.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 03</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 03</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 22.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 25.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 23.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 28.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 04</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 04</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 30.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 21.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 18.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 17.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 16.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">MNO</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 05</TD><TD class="xl70" style="border-top: none; border-left: none;">MNO 05</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 15.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">ABC</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 001</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 10.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 14.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">DEF</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 002</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 12.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">DEF 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 13.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">GHI</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 003</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 15.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">GHI 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 10.00 </TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">JKL</TD><TD class="xl70" style="border-top: none; border-left: none;">MAIN 004</TD><TD class="xl71" style="border-top: none; border-left: none;"> £ 8.00 </TD><TD class="xl70" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl70" style="border-top: none; border-left: none;">JKL 06</TD><TD class="xl73" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR><TR><TD class="xl74" height="21" style="border-top: none;">MNO</TD><TD class="xl75" style="border-top: none; border-left: none;">MAIN 005</TD><TD class="xl76" style="border-top: none; border-left: none;"> £ 9.00 </TD><TD class="xl75" style="border-top: none; border-left: none;">SUPPLIER 06</TD><TD class="xl75" style="border-top: none; border-left: none;">MNO 06</TD><TD class="xl77" style="border-top: none; border-left: none;"> £ 8.00 </TD></TR></TBODY></TABLE><P>Excel file enclosed for your reference.</P><P>Please help...</P></BODY></HTML> Mon, 05 Aug 2013 08:37:53 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/557501#M208136 MK_QSL 2013-08-05T08:37:53Z Re: Crosstable? https://community.qlik.com/t5/QlikView/Crosstable/m-p/557502#M208137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>See the file attached.</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Mon, 05 Aug 2013 08:53:46 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/557502#M208137 daveamz 2013-08-05T08:53:46Z Re: Crosstable? https://community.qlik.com/t5/QlikView/Crosstable/m-p/557503#M208138 <HTML><HEAD></HEAD><BODY><P>As far as my question, this formula working fine. But what about if we have suppliers as having different names instead of SUPPLIER 01, SUPPLIER 02.... etc ...</P><P>i.e.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="144"><TBODY><TR><TD class="xl63" height="20" width="81">SUPPLIER 01</TD><TD class="xl64" style="border-left: none;" width="63">Germany</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">SUPPLIER 02</TD><TD class="xl64" style="border-top: none; border-left: none;">France</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">SUPPLIER 03</TD><TD class="xl64" style="border-top: none; border-left: none;">Italy</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">SUPPLIER 04</TD><TD class="xl64" style="border-top: none; border-left: none;">Poland</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">SUPPLIER 05</TD><TD class="xl64" style="border-top: none; border-left: none;">USA</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">SUPPLIER 06</TD><TD class="xl64" style="border-top: none; border-left: none;">UK</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 05 Aug 2013 09:25:27 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/557503#M208138 MK_QSL 2013-08-05T09:25:27Z Re: Crosstable? https://community.qlik.com/t5/QlikView/Crosstable/m-p/557504#M208139 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the attached for solution.</P><P></P><P>Regards</P><P>Celambarasan</P></BODY></HTML> Mon, 05 Aug 2013 09:29:24 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/557504#M208139 CELAMBARASAN 2013-08-05T09:29:24Z Re: Crosstable? https://community.qlik.com/t5/QlikView/Crosstable/m-p/557505#M208140 <HTML><HEAD></HEAD><BODY><P>Thansk .....</P></BODY></HTML> Mon, 05 Aug 2013 09:38:17 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/557505#M208140 MK_QSL 2013-08-05T09:38:17Z