topic Re: Simple? How can I create a crosstable in QlikView? in QlikView https://community.qlik.com/t5/QlikView/Simple-How-can-I-create-a-crosstable-in-QlikView/m-p/419572#M560287 <HTML><HEAD></HEAD><BODY><P>Use the pivot table chart type instead of the straight table. In the pivot table you can maneuver a dimension to horizontal by dragging it to the right just above the expression(s). When you see a horizontal double-arrowed blue line you can let go and the dimension should be displayed horizontally.</P></BODY></HTML> Thu, 02 May 2013 08:00:46 GMT Gysbert_Wassenaar 2013-05-02T08:00:46Z Simple? How can I create a crosstable in QlikView? https://community.qlik.com/t5/QlikView/Simple-How-can-I-create-a-crosstable-in-QlikView/m-p/419571#M560286 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an Excel file to load my data from that is actually a crosstable - so the correct way would be to load it as a crosstable which gives me three fields - two for the dimensions and one for the data.</P><P>So far no problem.</P><P>How can I create the same thing again in QlikView now (a crosstable)? When I select the diagram type "straight table", I have the option of ticking a checkbox "horizontal" on the presentation tab, but then all my dimensions will be horizontal which is not what I want. One dimension should remain vertical, the other should be horizontal.</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 02 May 2013 07:57:17 GMT https://community.qlik.com/t5/QlikView/Simple-How-can-I-create-a-crosstable-in-QlikView/m-p/419571#M560286 datanibbler 2013-05-02T07:57:17Z Re: Simple? How can I create a crosstable in QlikView? https://community.qlik.com/t5/QlikView/Simple-How-can-I-create-a-crosstable-in-QlikView/m-p/419572#M560287 <HTML><HEAD></HEAD><BODY><P>Use the pivot table chart type instead of the straight table. In the pivot table you can maneuver a dimension to horizontal by dragging it to the right just above the expression(s). When you see a horizontal double-arrowed blue line you can let go and the dimension should be displayed horizontally.</P></BODY></HTML> Thu, 02 May 2013 08:00:46 GMT https://community.qlik.com/t5/QlikView/Simple-How-can-I-create-a-crosstable-in-QlikView/m-p/419572#M560287 Gysbert_Wassenaar 2013-05-02T08:00:46Z