topic Re: Cross table columns into multiple field boxes in QlikView https://community.qlik.com/t5/QlikView/Cross-table-columns-into-multiple-field-boxes/m-p/660940#M1078466 <HTML><HEAD></HEAD><BODY><P>It is not clear to me what you want to do... A crosstable cannot have fewer than three entities: In the picture below: Product, Month and Sales. Hence (at least) three fields.</P><P></P><P><IMG alt="Crosstable transformation4.png" class="jive-image" src="/legacyfs/online/62300_Crosstable transformation4.png" style="width: 620px; height: 285px;" /></P><P>HIC</P></BODY></HTML> Fri, 11 Jul 2014 14:38:00 GMT hic 2014-07-11T14:38:00Z Cross table columns into multiple field boxes https://community.qlik.com/t5/QlikView/Cross-table-columns-into-multiple-field-boxes/m-p/660939#M1078464 <HTML><HEAD></HEAD><BODY><P>I have successfully imported data using the cross table function.&nbsp; This created 3 list boxes.</P><P></P><P>Now I see that segmenting the columns from my original XLSX file into 2 list boxes would really be best for my analysis.&nbsp; What is the best course of action?</P><P></P><P>I've tried entering the load script twice and commenting out the desired columns for each respective statement but was unsuccessful..</P></BODY></HTML> Fri, 11 Jul 2014 12:55:23 GMT https://community.qlik.com/t5/QlikView/Cross-table-columns-into-multiple-field-boxes/m-p/660939#M1078464 2014-07-11T12:55:23Z Re: Cross table columns into multiple field boxes https://community.qlik.com/t5/QlikView/Cross-table-columns-into-multiple-field-boxes/m-p/660940#M1078466 <HTML><HEAD></HEAD><BODY><P>It is not clear to me what you want to do... A crosstable cannot have fewer than three entities: In the picture below: Product, Month and Sales. Hence (at least) three fields.</P><P></P><P><IMG alt="Crosstable transformation4.png" class="jive-image" src="/legacyfs/online/62300_Crosstable transformation4.png" style="width: 620px; height: 285px;" /></P><P>HIC</P></BODY></HTML> Fri, 11 Jul 2014 14:38:00 GMT https://community.qlik.com/t5/QlikView/Cross-table-columns-into-multiple-field-boxes/m-p/660940#M1078466 hic 2014-07-11T14:38:00Z